One drive :-
One Drive is the Microsoft cloud service that connects you to all your files. It lets you store and protect your files, share them with others, and get to them from anywhere on all your devices. When you use One Drive with an account provided by your company or school, it’s sometimes called “One Drive for work or school.” It used to be known as “One Drive for Business,” so you may still see it called that in places.
Here we will discuss how to integrate one drive data with power app. For that first we need to create a canvas app in power app and then we will connect with the one drive for business and then will update the data in excel sheet inside the one drive business.
Go to Microsoft 365 home page -> app launcher -> one drive for Business-> new-> folder -> new-> excel workbook
Create an excel sheet as shown below by inserting a table
Now Go To power app studio and create a new canvas app and name it as “Products onfo app” as shown below
Add The data source as Onedrive for Business
It will list all the folders in the OneDrive , Here i am selecting my folder i.e canvasapp folder -> products excel
sheet
Then your data is added to the power apps as shown below
Insert an Edit form to the screen
Add the OneDrive Table as data source to the Edit form
Add the Fields to the Edit form By Going to “Edit fields”
Preview the app to Add the items to the Edit form , but it won’t show any fields because the Mode of the form is in “Edit”
Change the Form mode to the “New ” to Add the new items to the form
Once you preview the app it will ask the Fields to enter
To submit the Form Add a Button control to the screen and write the following function in the onselect property of the Button
Now preview the app and add the new items and tap on save Button
The new items are added to the products Excel sheet in the OneDrive
Add a Success screen to the App
Add the following text in the success screen
Add a button control to the success screen and Add the navigate function to the Button in the Onselect property of the Button
Make some changes to the Button control by adding resetform and navigate functions in the formula,
So that when you tap on the Add new products Button it will navigate to the screen 1
Once you navigate to the screen 1 it will ask to enter New items and you can Save the items to the excel sheet by tapping on Save Button.
