Forum Discussion
lucas_ignatius
Sep 14, 2021Brass Contributor
How to Update list with Lookup column
I need to update List with Lookup Column but there will be update all column on List Budget Master Category.
Could this possible to update List 1 (Budget Master Category) only based on ID on List 2 (Transaction Budget Master Category)?
Example :
Input amount on ID 601 in List 2 (Transaction Budget Master Category, and will be updated to List 1 (Budget Master Category) but will updated all amount column ID. What I need is only update ID 601 on SharePoint List 1 (Budget Master Category), and it will increase amount column (with SUM Formula)
I hope my explanation make it easy for everyone to understand my problem
These are my SharePoint List 1 (Budget Master Category)
These are my SharePoint List 2 (Transaction Budget Master Category)
There are my flow
Thank you
- suvi-15Brass Contributor
As i understood your scenario that
List 2(Transaction Budget Master Category)
ID Input Amount
601 10,000
List 1(Budget Master Category)
Amount
10,000
20,000
30,000
After processing
List 1(Budget Master Category)
Amount
10,000 + 10,000
20,000 +10,000
30,000 +10,000
List 1 Amount + Input Amount(List 2 ID-601)
if this is scenario then
(is there 1 row with ID 601 or more than 1 in List 2)
filter List based upon ID=601 then you can use OData Filter Query option of Get Items as ID eq '601' ( you can search more on this how to use)
if its more than 1 then use Apply to Each on Value output from Get Items(Filtered) and take SUM of Input Amount .
I think you are doing later part properly by apply each action to List 1 and doing action as you want.
I hope this helps to you if i understood your scenario correctly 🙂
- lucas_ignatiusBrass Contributor
Hi suvi-15
(Is there 1 row with ID 601 or more than 1 in List 2)
Yes have more than 1 ID
I was try about "OData Filter Query option of Get Items as ID eq '601' ( you can search more on this how to use)"
There is nothing happened
if its more than 1 then use Apply to Each on Value output from Get Items(Filtered) and take SUM of Input Amount .
I'm not understand can you give me picture for this?
- suvi-15Brass Contributor
yes in Get Items you can see Filter query option
well there are other ways (like Filter array or Condition) as well but this one is good one in terms of Performance of flow