Power Platform Community Forum Thread Details

Update Salesforce record when Sharepoint Item is modified

Hello! I have 2 flows I'm working with to populate data from Salesforce to SharePoint when an emergency service case is entered and then write the other data back into Salesforce.

Flow #1- When an emergency case created in Salesforce, a new item is created in a SharePoint List. This flow works as expected and the list item is created and email notifications are sent out to the respective parties.

Flow #2 and where I'm struggling - When a certain column in the SharePoint list from flow 1 is modified, I want to then "write" that updated data back into the associated Salesforce case. My flow is writing the data back into Salesforce, but not just to the case associated with the updated item. It's writing it back to ALL open cases.

Each Salesforce Case has a case number that's auto associated with it upon creation. I also have this case number populating to my SharePoint list so I could use it in a condition action in my flow to compare the case number of the updated list item to the case number in Salesforce. I thought this would work to update only the case that matched the one updated in the list, but it did not work since it's updating ALL cases.