Hi Community,
I'm struggling to get the formula when there is one collection ie., Collection1 which consists of three columns Name, Email, ItemID and second collection containing three columns ItemName, ItemDescription, Quantity. I would like to Patch records to a sql table which has four columns Item, ItemName, ItemDescription,Quantity. What would be the formula in these scenarios where ItemID is in one collection and ItemName, ItemDesc and Quantity are in another collection. Do I need to use ForAll to update multiple records in sql server?
Thank you!

Report
All responses (
Answers (