Power Platform Community Forum Thread Details

I have a similar ask to this post, for which there was not a solution provided. (Near as I can tell the comment about local collection is referring to PowerApps not Automate?) https://powerusers.microsoft.com/t5/General-Power-Automate/Flow-to-sync-SharePoint-List-with-Excel-Table/m-p/376485

My Scenario:
Monthly, an Excel file is updated and sent as attachment to a share inbox in Outlook. I have a flow that will capture that attachment and save it to SharePoint, overwriting the file that is there. Thus my list update will be triggered by a change to that file. The file will have a table, with same name, column names, content etc. There are columns that are not to be shared/not being copied to the SP list, so the file will have to be in a 'secure' library I believe. (I wanted to use Excel power query to extract the data to a different file so only public data was in the library, but I can't find a way to have a flow open the Excel file and refresh the queries to reflect updated source file data.)

I have found videos etc that show how to add and update items in the list (Reza's version for example https://www.youtube.com/watch?v=uEZI_b1Gs-k), but none of them show how to delete from list rows that are no longer present in the Excel file. The test list is max 300 entries, but this process will be scaled to 1600 and possible thousands.

I am open to another method of extracting and using the data as well, if there is a better process option. I need the list data for my Power App, and it needs to be current (monthly right now, with possibility to direct save modified file and avoid the email method). This is org data, so will be matching based on email address (text) to determine matches etc.

If it matters, the flows are part of a PowerApps solution but are not triggered by the App, just by the file attachment/modifications.

Thanks.

Categories:

Building flows