Show Drop Down Values based on another list column in Power Apps
How to populate drop down values from SharePoint lookup lists.
In this article we are going to see, how to show drop down values to book interview slot
based on available date and time in power apps.
In our requirements dates and time are static , we are maintain those values in SharePoint lists.
Created 3 lists.
Book Date :
Book Time:
Connected 3 lists and added Edit form and connected Book Slot , Changed the Default form mode to New
cannot be loaded because running scripts is disabled on this system
cannot be loaded because running scripts is disabled on this system.
File C:\Users\Raavi\Documents\CreateFolders.ps1 cannot be
loaded because running scripts is disabled on this system. For more
information, see
about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
+
CategoryInfo : SecurityError:
(:) [], ParentContainsErrorRecordException
+
FullyQualifiedErrorId : UnauthorizedAccess
Solution : This issue will happened when running script is disabled in our machine , to run the script
Run this command this will allow us to run the scripts
set-ExecutionPolicy RemoteSigned -Scope CurrentUser
After clicking on Yes , we can again check the status Get-ExecutionPolicy
OneDrive interview questions
OneDrive interview question and answers are very important , this will be very helpful who are preparing for OneDrive for business interview.
1)How many ways we can access users OneDrive?
a)From Admin centre
b)SharePoint User profile
c)using PowerShell
2) When should I use OneDrive for business instead of
SharePoint or Teams?
All are cloud-based storage, we can say in simple terms
OneDrive is your own personal site , we can storage office documents ,
images which you don’t want to share
with your organization or team members
, Example : you are working an document
in draft stage or not yet ready to share with others in that case we can use
OneDrive ..
Using OneDrive sync client, we can use it as local hard
drive .. we can modify and edit all the
files from local machine or laptop very easily, you can login with you account and
access as these files from any device ...
3)What is OneDrive for business and OneDrive for Personal?
Both represents the same name
OneDrive personal: it is used to sync and store your
personal files share it with family and friends, we will get it for free with
Microsoft account ... outlook or Hotmail
We will get 5GB of free space by default, we can extend if
required with cost.
It provides personal vault to store important documents with
two step verification
OneDrive for Business: we can share your Files,
Documents and collaborate with your origination team members or with external
users.
This is managed by your organization.
It is having 1 TB of storage for most of subscriptions, we
can also extend up to 5TB.
Most secure, reporting and auditing options available.
4)Different type of sync issues?
Storage is full
OneDrive is in read only mode
File length is too long
Having Special characters
RESET your onedrive
5)How to remove special characters in OneDrive documents?
Using PowerShell
6)How to recover deleted files from OneDrive?
We can recover the deleted files from OneDrive recycle bin , within 93 days
7)What is the default storge limit for OneDrive?
Default storage is 1 TB for most of the subscription plans,
we can increase the storage space up to 5 TB
8)What are the special characters OneDrive won’t allow?
" * : < > ? / \ |
9)What is file on demand?
OneDrive File on demand, will helps you access all your
files in OneDrive without using storage on your device.
10) How to get the OneDrive usage for all users?
Using PowerShell
#Output location
$CSVFile = "D:\OneDrives.csv"
#Connect to SharePoint Online Admin Center
Connect-SPOService -Url
"https://yourtenant-admin.sharepoint.com"
#All OneDrive Sites usage details and export to CSV
Get-SPOSite -IncludePersonalSite $true -Limit all -Filter
"Url -like '-my.sharepoint.com/personal/'" | Select URL, Owner,
StorageQuota, StorageUsageCurrent, LastContentModifiedDate | Export-Csv -Path
$CSVFile -NoTypeInformation
SharePoint Online Admin Inteview Questions
SharePoint Interview Questions , In this article we can see what are all the questions recently asked in the interview on SharePoint .
Prepare all these SharePoint Online Interview Questions , most of the company's are asking these questions.
SharePoint Interview Questions - Part 1
SharePoint Interview Questions - Part 2
1)What Is hub site?
2)Difference between authentication and authorization ?
3)How you will restore deleted site collection?
4)While accessing the SPO site/page you will get Correlation ID , how you will find error in ULS Logs ?
5)Is it possible to rename the SPO site collection URL?
6)Users are not able to access spo site?How you will trouble shoot ?
7)Types of admin roles ?
8)External user is not able to access SPO site how you will trouble shoot ?
9)How you will increase site collection quota?
10)how users will sync from On Prem AD to azure AD?
create modern team site without Microsoft 365 group
SharePoint online interview question and answers
SharePoint online interview question and answers are very important for interview point of view .Please prepare all these SharePoint interview questions before attending interview.
SharePoint interview Questions
2) What is the Max no of sub sites we can create under each site collection ?
4) Can you please list down the site templates available in SPO?
5)How you will enable scripting ?
6) Can we hide default “Title” column in list?
7)User having full control but still not able to access SPO site?
8) How you will increase list view threshold limit in SPO ?
9)how you will deploy app at site collection level?
10)Can you list down the PowerShell commands that used frequently ?
ValidateCredentialClaims – Access Denied: Claims stored in the credentials did not match with the group claim for a group app
ValidateCredentialClaims
– Access Denied: Claims stored in the credentials did not match with the group
claim for a group app
We got an issue when uses are trying to access external list in SharePoint 2013 “Unable to render the data, If the problem persists, contact you web server administrator” with correlation id XXXXXX-XXXX-XXXXXX
Using this correlation
id, I am able to find error message as per the below in the log file, also we
can see the entity name it is a target application name, which we need to fix
this issue.
ValidateCredentialClaims
– Access Denied: Claims stored in the credentials did not match with the group
claim for a group app.
Solution:
Open Central admin -> Application Management -> Manage Service applications
In the Next screen , we can able to
see list of target applications we are using.
In the log file we can
see the Entity name it will be same as Target Application name.
Click on the Target
Name-> Click next couple of times.
Finally we can able to
see the screen shot as per the below.
Provide access either
for individual user who ever reported the issue or everyone in your organization, based on the requirement
and Click ok.
Click on External list
that you are facing issue , now issue will disappear , if you are still facing
the issue try in private browser or do an IIS reset.
Create communication site in SharePoint online
How to create communication site in SharePoint online.
What is communication site?
communication site is used to share information
with team or organization, such as news, product information, topics, events etc.
SharePoint Online Interview Questions
How to create modern team site in SharePoint online
Few important points on communication site.
communication sites are not connected with
O365 Groups.
communication sites having 3 pre build templates
(Now Microsoft removed at the time of site creation)
Topic
Engage viewers with informative content
like news and events.
Site capabilities
Highlight news and announcements
Promote upcoming events
Surface related content and resources
Showcase
Spotlight a product, event, or team using
visual content.
Site capabilities
Share related content and resources
Spotlight visual content like images
Create calls to action
Blank
Create your own custom site starting with a
blank home page.
Site capabilities
Blank home page
Hero webpart is added by default for communication
site templates(Topic, Showcase)
How to create Communication site
Step 1
Open https://www.office.com/
URL or any SharePoint online site
Click on App launcher and click on
SharePoint as per the below screen shot.
Step 2: Click on Create site and click on Communication site
Step 3: Enter the site name, site description,
select language based on your requirement
Click on Finish
By default,
it will create with Topic template
If we want to change to another template (Showcase,
blank)-> click on settings gear icon -> click on Apply a site template
Select the template you want to apply ->
Click on Use Template.
Create a modern team site collection in SharePoint online
Modern team sites are integrated with
office365 connected groups, once we created a team site, it will create a SharePoint
site, with Office 365 group , email id, we can add group owner, we can also
change the privacy settings either private or public.
How to create communication site in SharePoint online
Difference between SharePoint Onprem vs Online
If Self site creation is disabled in your organization
level, we need to navigate to SharePoint admin center to create new sites.
Steps to create a modern team site
Step 1: Open
SharePoint admin center
Click on Active sites -> Click on
Create
![]() |
We can see popup to create a new Team site and commutation site
Step 2: Click on Team site -> Enter the site name, same name will populate to group email address and site address. Provide the site owner.
By default, team site will create as private
group site, if you want to make it public, click on the Advanced settings,
select the options as per the requirement.
Step3: If we want to add additional owners or members,
we can able to add as per the below screen and click on finish
Now we able to see the newly created site
in SharePoint admin center.
Difference between SharePoint Onprem and Online
In this article we can see the major difference between SharePoint on premise and SharePoint Online
How to create a modern team site collection in SharePoint online
Create communication site in SharePoint online
OnPrem |
Online |
SharePoint farm’s will be hosted, managed/maintained
by your company. It will be more cost to manage. |
SharePoint farms are hosted, managed/maintained by Microsoft,
it is a cloud-based solution, we can reduce the cost. |
Company IT staff will be responsible for patching, updates,
related to SharePoint, windows updates. |
Microsoft will take care of installing patching and updates |
Our Origination team needs to make sure sites are up
and running always. |
Microsoft has committed to 99.9% |
SharePoint sites can be accessible only within the organization
network, or based on own configuration we can access outside as well. |
SharePoint online sites can able accessible from in
and outside of Origination, any device. |
More
number of team members required to manage SharePoint, having dependency on
other teams, Network, AD, IIS, Security, Database, windows teams. |
Microsoft will take care, if there is any planned
activity MS will announce we can see in the Service health page. |
Your company need to buy license for each server, either
standard or enterprise, and for office applications. |
Microsoft will provide license based on our usage/requirement
in Office 365 enterprise or business license. |
SharePoint Onprem will support server-side coding,
client side. |
SharePoint online supports Client side, SPFX |
SharePoint Online Interview Questions
How to move OneNote to another location
In our daily work we can see users will
faces some issues related to OneNote, if user changed the laptop or system crash,
we might lose OneNote data, to avoid such issues most of people will use OneDrive
to syn OneNote’s.
Open OneNote from your machine.
Click on File , here we can able to
see the OneNote we are using
Click on Settings Icon, next to the OneNote
name you want to move.
In our example, we will move “MyOwnNote”
Select the OneDrive as per the below, click
on Move Notebook or select the different folder to move this OneNote.
Now we can see our OneNote is syncing to OneDrive.
Hope this will be helpful when we want to change
the location of OneNote.
How to restore deleted OneNote
In this article we can see how to recover the deleted OneNote. In most of cases we need to work how to restore the deleted OneNote, end user might delete unknowingly.
OneNote for windows 10 version and OneNote for office Microsoft 365
Windows 10 OneNote APP.
Method:1
Open the OneNote App from the your machine .
As per the below screen shot click on File
Click on Open Backups
Select the notebook section , inside we can able to see “OneNote_Recyclebin”
Select the .one file and click on open , once we opened in OneNote app right click and click on Move or copy , you can copy the OneNote file based on the user requirements.
Method : 2
We can also verify from OneNote APP
Open the required section , there Click on the History tab-> Click in Notebookrecycle bin
We can able to see the deleted notes in the right hand side and click on Move or Copy , then we can do based on the user confirmation .
In case if you are not able to find, make sure we are checking right account and verify OneDrive and machine recycle bin , if possible get the name of the OneNote and search in the entire machine and OneDrive.
Hope this will helps to recover the deleted data.
Restore deleted sub site in SharePoint Online
Today we
got an issue, end user deleted sub site by mistake and they want us to restore
the sub site immediately. Since this is a sub site I checked at Recycle bin for
that navigate to Site settings
https://yoursharepoint.sharepoint.com/sites/PK/_layouts/15/settings.aspx
https://yoursharepoint.sharepoint.com/sites/PK/_layouts/15/AdminRecycleBin.aspx?view=5
In Primary
recycle bin we are not able to find that Sub site.
Solution
In the same
URL we can able to see the secondary recycle bin as per the below screen shot
We are able
to find that deleted sub site at secondary recycle bin as per the below URL
https://yoursharepoint.sharepoint.com/sites/PK/_layouts/15/AdminRecycleBin.aspx?view=13
Select that
particular sub site and click on restore.