Hello everyone,
have an app with companies which trade may trade with each other. The goal of the app is for users to indicate which company can trade with each other. In sum all data is stored in a table like:
As there are about 83 companies, I created a PowerApps gallery to ask users to indicate such trading capability.
My problem is: A trade goes both ways, if A can trade with B, B can trade with A. How to I update the Trade value of "B trading with A" when user select "A trading with B"?
I thought of loging the change to powerapps in sharepoint and doing the update on the opposite value through Power Automate. My first idea was to create an Marker column with the combination of origin and destination and use such relationship and use that as identifier in power automate to update the trade column.
But I couldn't figure how to add such action in Power Automate as 'Sharepoint Update item' sharepoint requires an ID value. How can I trace the ID of the opposing selection? In my example Marker AB.ID = 1 and its opposing Marker, BA.ID = 4. How I tell Power Automate to change ID 4 with the same Trade Value of ID 1?
Any suggestions on how to update this? I am open to going different directions to solve this problem.
Thanks for the support!
