New issue, Not sure how to Fix. Data collection - population in Power App
I have followed the instructions from @RandyHayes in this Link here Here is my methodology, and maybe this is where my issue is. 1. I export a file to a csv - contains 200 rows. (Daily - it changes)
2. I use Power Automate desktop, to clean up the files, adds a column with the current date, and creates a table.
3. I save this file to one drive as an .xlsx file. named the same every time (replaces the old file)
4. I run a cloud power automate to delete all entries on a SharePoint list. then populate it with the new information from the .xlsx file.
5. PowerApps pulls the file into the App populating it with new data.
I know at times I over complicate things, so any suggestions on refining this, is appreciated. I am extremely new to all of this. the error I have now is that the cloud power automate flow, on the list rows present in table.
the table on this is named the same in the new file, but on the flow is goes to a guid, and I have to basically reset up this step each time. ( means not fully automated...:( )
Any suggestions on how to revamp or fix my issues?