Hello All,
1. We would like to sync/update/append the data in the Excel/CSV file in One drive for business everyday into a master file. Is it possible?
2. Is it possible to automate the conversion of excel to the table to use it as a data source?
Solved! Go to Solution.
Hi @GayathriSK ,
Do you want to use Excel in OneDrive for business as the data source of Power Apps?
Yes, you could. Please reference to below link of official docs to know the whole steps of add an Excel file in OneDrive for business into PowerApps as the data source:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/get-started-create-from-data
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/get-started-create-from-blank
CSV files are not supported to be used as data source since they could not be formatted as tables. Excel worksheets need to be formatted as tables before you create a canvas app based on data in worksheets. Please see below doc to know how to format a table in Excel:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/how-to-excel-tips
But you would be supposed to know there are some limitations on using Excel in cloud storage services as data source:
For your second question, could you please share more details about your scenario? Do you want to automate generating Excel worksheets and format them into tables?
If you do, I’m afraid there is no way to achieve your need by now. You could create Excel worksheet in Power Apps through MS Flow automatically but still need to format it into a table in Excel.
Hope this helps.
Hi @GayathriSK ,
Do you want to use Excel in OneDrive for business as the data source of Power Apps?
Yes, you could. Please reference to below link of official docs to know the whole steps of add an Excel file in OneDrive for business into PowerApps as the data source:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/get-started-create-from-data
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/get-started-create-from-blank
CSV files are not supported to be used as data source since they could not be formatted as tables. Excel worksheets need to be formatted as tables before you create a canvas app based on data in worksheets. Please see below doc to know how to format a table in Excel:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/how-to-excel-tips
But you would be supposed to know there are some limitations on using Excel in cloud storage services as data source:
For your second question, could you please share more details about your scenario? Do you want to automate generating Excel worksheets and format them into tables?
If you do, I’m afraid there is no way to achieve your need by now. You could create Excel worksheet in Power Apps through MS Flow automatically but still need to format it into a table in Excel.
Hope this helps.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
184 | |
71 | |
43 | |
34 |
User | Count |
---|---|
338 | |
266 | |
116 | |
66 | |
66 |