I have a flow where whenever user update an excel file (located in SP library), SP list will be updated and store the newly added data and send email to appointed user , the email contain data that is newly added . but the issue is whenever i run the flow, the email will contain every list in my SP . i wonder how do i set it to send only newly added data ?
Thank you in advance!
@norashura below are the details:
1. Add SPItemID column to your spreadsheet (you wont be able to make it hidden as flow requires it to be visible, if you want to hide it probably you can make its width too small and move it to being last column in spreadsheet)
2. Then in the "List rows present in a table" action add a filter query as below. This will get only those rows where SPItemID is blank
SPItemID eq ''
3. Within the loop after create item action, add Update Row action and configure it as shown in below screenshot
In Key Column, provide the name of column which will uniquely identify the row the flow needs to update with the newly created SharePoint list item ID. Here you are updating the SPItemID with the newly created SharePoint list item ID so that again when your flow runs this row will not be processed by flow.
by any chance can you me an example of flow ?
@norashura i think you will need hidden column in excel to store whether the row is added to SharePoint list or not and once items are added in SharePoint list you need to update the column to update that column.