You’re offline. This is a read only version of the page.
3
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}))
Hi @Diogo
Can you try to update the expression to:
ForAll(Gallery3.AllItems;Patch(Gestao_TI;LookUp(Gestao_TI; ITEM = item_req);{QTDE:LookUp(Gestao_TI; ITEM = item_req).QTDE-qtde_req}))
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Share
Report
All responses (
Answers (
