Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

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?



Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,458)