How to Update list with Lookup column

%3CLINGO-SUB%20id%3D%22lingo-sub-2748158%22%20slang%3D%22en-US%22%3EHow%20to%20Update%20list%20with%20Lookup%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2748158%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20update%20List%20with%20Lookup%20Column%20but%20there%20will%20be%20update%20all%20column%20on%20List%20Budget%20Master%20Category.%3C%2FP%3E%3CP%3ECould%20this%20possible%20to%20update%20List%201%20(Budget%20Master%20Category)%20only%20based%20on%20ID%20on%20List%202%20(Transaction%20Budget%20Master%20Category)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CEM%3EExample%3C%2FEM%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CP%3E%3CEM%3EInput%20amount%20on%20ID%20601%20in%20List%202%20(Transaction%20Budget%20Master%20Category%2C%20and%20will%20be%20updated%20to%20List%201%20(Budget%20Master%20Category)%20but%20will%20updated%20all%20amount%20column%20ID.%20What%20I%20need%20is%20only%20update%20ID%20601%20on%20SharePoint%20List%201%20(Budget%20Master%20Category)%2C%20and%20it%20will%20increase%20amount%20column%20(with%20SUM%20Formula)%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20my%20explanation%20make%20it%20easy%20for%20everyone%20to%20understand%20my%20problem%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThese%20are%20my%20SharePoint%20List%201%20(Budget%20Master%20Category)%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EThese%20are%20my%20SharePoint%20List%202%20(Transaction%20Budget%20Master%20Category)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%224.png%22%20style%3D%22width%3A%20592px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310221iDB02431C055BBDAF%2Fimage-dimensions%2F592x112%3Fv%3Dv2%22%20width%3D%22592%22%20height%3D%22112%22%20role%3D%22button%22%20title%3D%224.png%22%20alt%3D%224.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThere%20are%20my%20flow%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%221.png%22%20style%3D%22width%3A%20309px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310217iEE89F94C378A5A77%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221.png%22%20alt%3D%221.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222.png%22%20style%3D%22width%3A%20308px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310218i404DA44697119F6E%2Fimage-dimensions%2F308x642%3Fv%3Dv2%22%20width%3D%22308%22%20height%3D%22642%22%20role%3D%22button%22%20title%3D%222.png%22%20alt%3D%222.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2748158%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2748300%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Update%20list%20with%20Lookup%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2748300%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F999750%22%20target%3D%22_blank%22%3E%40lucas_ignatius%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20i%20understood%20your%20scenario%20that%3C%2FP%3E%3CP%3EList%202(%3CEM%3ETransaction%20Budget%20Master%20Category)%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EID%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BInput%20Amount%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E601%26nbsp%3B%20%26nbsp%3B%2010%2C000%3C%2FEM%3E%3C%2FP%3E%3CP%3EList%201(%3CEM%3EBudget%20Master%20Category)%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EAmount%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E10%2C000%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E20%2C000%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E30%2C000%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E%26nbsp%3B%3CSTRONG%3EAfter%20processing%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3EList%201(%3CEM%3EBudget%20Master%20Category)%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EAmount%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E10%2C000%20%2B%2010%2C000%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E20%2C000%20%2B10%2C000%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E30%2C000%20%2B10%2C000%3C%2FEM%3E%3C%2FP%3E%3CP%3EList%201%20Amount%20%2B%20Input%20Amount(List%202%20ID-601)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20this%20is%20scenario%20then%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E(is%20there%201%20row%20with%20ID%20601%20or%20more%20than%201%26nbsp%3B%20in%20List%202)%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E%26nbsp%3Bfilter%20List%20based%20upon%20ID%3D601%20then%20you%20can%20use%20OData%20Filter%20Query%20option%20of%20Get%20Items%20as%20ID%20eq%20'601'%20(%20you%20can%20search%20more%20on%20this%20how%20to%20use)%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3Eif%20its%20more%20than%201%20then%20use%20Apply%20to%20Each%20on%20Value%20output%20from%20Get%20Items(Filtered)%20and%20take%20SUM%20of%20Input%20Amount%20.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3BI%20think%20you%20are%20doing%20later%20part%20properly%20by%20apply%20each%20action%20to%20List%201%20and%20doing%20action%20as%20you%20want.%3C%2FP%3E%3CP%3EI%20hope%20this%20helps%20to%20you%20if%20i%20understood%20your%20scenario%20correctly%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2748421%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Update%20list%20with%20Lookup%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2748421%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F999750%22%20target%3D%22_blank%22%3E%40lucas_ignatius%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyes%20in%20Get%20Items%20you%20can%20see%20Filter%20query%20option%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22suvi15_0-1631611625243.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310240iAE3EDD65DC9A06DC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22suvi15_0-1631611625243.png%22%20alt%3D%22suvi15_0-1631611625243.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ewell%20there%20are%20other%20ways%20(like%20Filter%20array%20or%20Condition)%20as%20well%20but%20this%20one%20is%20good%20one%20in%20terms%20of%20Performance%20of%20flow%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2748630%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Update%20list%20with%20Lookup%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2748630%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711566%22%20target%3D%22_blank%22%3E%40suvi-15%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20try%20but%20nothing%20happened%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%225.PNG%22%20style%3D%22width%3A%20291px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310269i5F4CEC7CB35FA6A5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%225.PNG%22%20alt%3D%225.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%226.PNG%22%20style%3D%22width%3A%20365px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310268iADB5B1F4AF6AE1E7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%226.PNG%22%20alt%3D%226.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%227.PNG%22%20style%3D%22width%3A%20331px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310270iC8F2C380A77DC5EE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%227.PNG%22%20alt%3D%227.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2748694%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Update%20list%20with%20Lookup%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2748694%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F999750%22%20target%3D%22_blank%22%3E%40lucas_ignatius%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20till%20before%20Apply%20to%20Each%203%20Action%20you%20get%20proper%20value%20for%20varVariance%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20you%20missed%20one%20step%20i%20suppose%20getting%20Items%20from%20BudgetItemsCategory(Get%20Items)%20.%20This%20list%20output(values)%20you%20have%20to%20refer%20in%20Apply%20to%20Each%203%20Action%20as%20you%20are%20updating%20list%20items%20in%26nbsp%3BBudgetItemsCategory%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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)

4.png

There are my flow

1.png

2.png

 

 

 


Thank you

8 Replies

@lucas_ignatius 

 

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 :)

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?

 

 

 

@lucas_ignatius 

 

yes in Get Items you can see Filter query option

suvi15_0-1631611625243.png

well there are other ways (like Filter array or Condition) as well but this one is good one in terms of Performance of flow

Hi @suvi-15 

I was try but nothing happened

 

5.PNG

6.PNG

7.PNG

@lucas_ignatius 

 

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

@lucas_ignatius 

 

How you want to trigger flow on the updation of TransactBudgetCategory item and with ID 601 ?

Hi@suvi-15 

I need when item created and modified