You’re offline. This is a read only version of the page.
19
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.
****UPDATE****
In case anyone else has this issue, through trial and error, I was able to resolve it by simply moving the "Send to Salesforce" action out of the for each "bucket". I'm not sure why Power Automate automatically added a for each to that action, but that was what was causing my issue. Now ONLY the associated case in Salesforce is being updated instead of all of them.
Share
Report
All responses (
Answers (
