Can you access Excel file that's stored sharepoint site

[Sahara22]

Hello,

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! 

[TheRobRush]

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

[Sahara22]

But wouldn't it just add to the list and not delete old items? 

[Sahara22]

opps I didn't see that last part you wrote, I will try that 

[TheRobRush]

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

[TheRobRush]

Hint: PowerAutomate by default just grabs top 100 items so change 

top count to 2000, underneath advanced options

[Sahara22]

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? 

[TheRobRush]

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

[Sahara22]

Email attachment. Its a excel sheet but not table formatted. 

[TheRobRush]

yah i got the email part, but who or what is generating the file to attach to the email

[Sahara22]

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