Need help to create excel sheet on One Drive For Business

Like (0) Share

Report

Posted on 6 Jul 2020 03:51:12 by Shailendra35

Hi All,

I recently start to learn Ms-Power App. In my first app while I click on "Create" Button for Creating a "One Drive for Business" I am getting below issue Issue URL: https://drive.google.com/file/d/1efKfxtQ8BpnQ0doRnKuwretvJljXOPtW/view?usp=sharing My One Drive and Google Drive not working. I also off Popup blocker and kept this web site in white list as well Please help me here.

Thanks

Categories:

Connecting to Data

All responses (2)

Answers (0)

v-bofeng-msft on 15 Jul 2020 at 06:39:22

Like (0)

Report

Re: Need help to create excel sheet on One Drive For Business

Hi @Shailendra35
Has the problem been solved?
Is there anything else I can help?
If the post is helpful, please consider accepting it as a solution to help others
Best Regards,
Bof
v-bofeng-msft on 06 Jul 2020 at 06:24:40

Like (0)

Report
Re: Need help to create excel sheet on One Drive For Business

Hi @Shailendra35 :
Do you want to use the data in the excel file in OnDrive as the data source?
Unfortunately, I cannot open the link you shared.But I can share the method of Connect to Excel from Power Apps to you:
Excel is kind of a connection. To display Excel data in your app:
1\Format the Excel data as a table.
2\Store the Excel file in a cloud-storage account, such as Box, Dropbox, Google Drive, OneDrive, and OneDrive for Business.
3\Connect to the cloud-storage account, and then add the Excel table as a data source.
4\Display this information in your app by generating an app automatically or by adding and configuring, for example, a Gallery control.
In addition,if you want to create an excel file on One Drive For Business,I'm afraid you can't do it with powerapps.
I think this link will help you a lot:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-excel
Best Regards,
Bof