I have a gallery called Gallery3 where the quantities of items requested are, I need to update the table in Sharepoint called GESTAO_TI for each item requested, based on the "ITEM" column, which is the same as the "item_req" field in Gallery3, I need to update the list GESTAO_TI the QTDE column with the updated quantity
GETAO_TI
ITEM QTDE
A 3
B 22
C 12
Gallery3
item_req qtde_req
A 2
B 5
C 11
I tried the code below, but it didn't work
ForAll(Gallery3.AllItems;Patch(Gestao_TI;LookUp(Gestao_TI; ITEM = Gallery3.AllItems.item_req);{QTDE:QTDE-qtde_req}))


Report
All responses (
Answers (