Unanswered

Update newly added list

(0) Share

Report

Posted on by norashura

141

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!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
norashura 141 on at

Like (0)

Report
Copy link

Link copied!

by any chance can you me an example of flow ?

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No