I have datesource excel sheet that employees need access to to use the power apps I made. If I were to put this excel sheet on a sharepoint site under documents, if there away I can access the table of that excel sheet? I have tried to add it as a connector but just adds as "documents only"
Any help would be great. Thank you!
Solved! Go to Solution.
You won't need to create a new list. Basic workflow is.
Check For Email > Get Data From Email> Get All Items Currently on List > Delete All Items > Create New Items > Done
No, because in my workflow I showed you there is a delete all items step. You just use the foreach action to delete all items that the previous get items action obtained, which clears your splist
Hint: PowerAutomate by default just grabs top 100 items so change
top count to 2000, underneath advanced options
Ok and last question, if the excel that gets sent in a email is not in table, would this still work? or would I have to make it into a table then do this?
Honestly have not touched excel in years so I am just guessing, but i THINK you need to have it generate a table. Where is this data originating from
yah i got the email part, but who or what is generating the file to attach to the email
Sorry and for the flow you suggested :
Check For Email > Get Data From Email (get attachments ?) > Get All Items Currently on List > Delete All Items (is there a condition to just delete? > Create New Items > Done