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.