12-09-2020 04:25 PM
If I have a SharePoint List with the following values:
SharePoint List A
PO Line Ordered Qty
1 A 100
1 B 100
2 A 200
3 A 400
SharePoint List B
PO Line PO Qty
1 A 100
1 B 200
2 A 400
3 A 600
Add a dynamic column in SharePoint List A to update PO Qty so I can create a calculated field Open Qty:
PO Line Ordered Qty PO Qty Open Qty
1 A 100 100 0
1 B 100 200 100
2 A 200 400 200
3 A 400 600 200
How can I do this action where I need to join off 2 columns (PO and Line)?