I learned that using a browsing method for the file path during table creation causes errors. This is because I replace the existing Excel file with a new one every day.
I quite don't understand what to put in the file identifier option in "get file metadata action" step 3
step 2
step 1
However when I browse my file and run the flow it gives me an error saying "invalid request/ this resource does not exist"
For context, my Power App connects to a SharePoint list. I receive daily data updates through email attachments. Upon receiving a new attachment, I follow these steps:
- Save the attachment to a SharePoint folder (no issues encountered here).
- Create a table (encountering errors at this step).
- Delete all items from the SharePoint list (confirmed to work correctly).
- Add all rows from the created Excel table as new items in the SharePoint list (unable to test due to errors in step 2).
Any insights into the cause of the errors would be appreciated.