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 ?
SharePoint online interview questions
In this article we are going to discuss about SharePointonline interview questions.
Before attending SharePoint interview , kindly read this SharePoint
question and prepare well, all these are real time SharePoint online interview questions.
We will cover basic SharePoint interview
questions and answers to advanced SharePoint interview questions.
1) What is the process you follow to create a new site in SharePoint online?
2) What is the Maximum storage limit for each site
collection in SharePoint online?
3) What is the different type of licenses we are having in
Office 365?
4)What is the difference between Modern team sites and
communication sites?
5)Difference between Contribute and Edit Permissions?
6) List down the webparts available in modern sites?
7)What is the difference between SharePoint Onprem and SharePoint
online?
8) With in how many days we can recover the deleted items
from the recycle bin?
9)How good you are in PowerShell scripting, did you worked on any automations?
10)How you will enable external sharing?
Hope all these SharePoint online admin questions will be helpful to clear the interview.
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.