Filling out fields in a SharePoint list

[Sbsyx]

I have created a flow that downloads data from List SharePoint, performs calculations based on this data and saves the information in Excel. This is a loop for 74 records. I need this calculated data to be written back to the sharepoint list, but some fields for some records will be empty. How to use update item to know for which record ID the data should be changed, and if there are none, leave the field empty?

In the flow I created, unfortunately it puts the same values ​​in all fields.

[Yasir_rd · Accepted solution]

@Sbsyx What is the trigger for your flow, If you are using list items then you have to use filter query to filter the records that are modified e.g. today, and process them in flow and update those only. Alternatively, you can also use the trigger " When an item or file is modified " to process only modified records, process them in flow, and update the SharePoint list. What is the objective of saving them in an Excel file is it to keep a change log? Let me know how you go. Thanks.

[Sbsyx]

Accept clicked accidentally...

This is an application in PowerApps for creating statements in Excel, only some of the data to create such a statement is in another Excel and in this SharePoint list. Automation creates the file itself and inserts new data into it or downloads data from sources. To create another statement, you need to add the calculations you have made to the list so that you can refer to them in the next automation that creates another statement. I will not refer to the Excel files because they are created on an ongoing basis.

[Yasir_rd]

@Sbsyx Could it be possible that your apply to each loop is not at the right location in the flow? It calculates one time and then just loops through all the list items and updates them with the same calculated values. I would suggest that you check the flow map either by using the Process mining option of just by looking at the flow to see that all the actions are at the right place. Thanks.

[Sbsyx]

Ok... I did it in several ways, here are the conclusions:

If I update the list outside the main loop, then the supplementary loop tries to insert this data collectively, i.e. 73 records into one field, but when I add it to the main calculation loop or Excel's supplementary loop, it adds the same data to all records.

I have no idea anymore...

[Yasir_rd]

@Sbsyx Hmm, can you please share snips of the flow steps from the start and including the trigger and actions related to the SharePoint list. I will have a look. Thanks.

[Sbsyx]

I'll have access to it on Monday and I'll send it to you.

Thank you