You’re offline. This is a read only version of the page.
Announcements
Hello guys,
I'm wondering if there is a good solution (or maybe even good practice) for keeping the data in SharePoint lists and Excel tables synchronized.
For a some background: I made a little diagram to show the flow of Information.
- I have people (teachers) updating data in a form (MS Forms)
- I have people (headmasters) updating the same data in a powerapp and checking the data of their respective school
- I have one person (analyst) who checks the data from all the schools in Excel.
Where I am now is: the whole right side is done and works nicely. I created individual flows for every school that will collect the answers in various tables in one file.
However, the Excel connector for Powerapps is kinda dodgy and I read in multiple places to work with SharePoint list when doing powerapps.
The analyst definitely needs this as an excel sheet that is always up to date to get all the relevant info (with conditional formatting etc.) at a glance.
So, somehow I need to get the two together and make sure that both are up to date.
The only way I can imagine is to change the flows of all Forms to append one SharePoint list, which is also connected to powerapps, and then have powerautomate update the Excel file with every Change in the SharePoint list.
Hi @schwibach
Consolidating all data in one place is the best way for the requirement so that you can do the export using Power Automate to generate the Excel file. Instead of doing every change why can't do schedule this at a certain interval and generate the full excel file.
Thanks
Share
Report
2
All responses (
Answers (
