You’re offline. This is a read only version of the page.
Announcements
29
Hi!
I have process that involves an excel file and 2 different sharepoint lists. Sharepoint list A (300 rows) and list B (500 rows).
The process is that when an excel file is uploaded to a folder in Sharepoint, loop through list A. If item exists, update it; if it does not then create new item. This is working fine.
The challenge I'm trying to work through is that there are 4 columns on list A that ARE NOT on the excel file. That is intentional as the excel file is exported from a system that does not contain the 4 columns.
These 4 columns are stored on list B.
So, what I want to do is, when a new item is created on List A, ONLY loop through those newly created items, get items from List B and update the columns of ONLY those newly created items. This is because I don't need to loop through all 300 rows on list A, when the flow runs there may only be 10-12 newly created items. I'm not sure how to add on to the existing flow.
I'm not sure if I add on directly under "Create Item" or go outside the Apply to each to continue the flow. I considered doing a condition outside the apply to each and set it to 'length of outputs of create item' greater than 0 then continue the flow but it's not working out as expected.
Any help is greatly appreciated!
Eli-G
You can consider two options:
1) like you mentioned immediately after you have created the item, add action Get corresponding item from List B and then add Update Item on List A withe the columns from List B (which you have received in Get item action.
2) create a new flow, with Trigger condition as "When an Item is created" on List A and then for the created item get the corresponding columns from List B and update List A
Share
Report
All responses (
Answers (
