Forum Discussion
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 ...
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?
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
I hope till before Apply to Each 3 Action you get proper value for varVariance .
I think you missed one step i suppose getting Items from BudgetItemsCategory(Get Items) . This list output(values) you have to refer in Apply to Each 3 Action as you are updating list items in BudgetItemsCategory list.
- Could you help for best flow? because I'm stuck