You’re offline. This is a read only version of the page.
Hi,
I am currently getting a list of contacts from a SQL database that has advanced segmentation done of CRM data.
I am currently running a for each loop in power automate to add a contact to a Customer Engagement (Dot Digital) address book, which could potentially already exist in our Customer Engagement platform but may not be in the address book.
When a contact is suppressed already in the Customer Engagement platform, the step in the flow returns a 404. Although I am handling this error by using a run on error step, i am unable to use a Terminate inside the for each. When the flow is finished it is showing as failed, so each day will show as failed.
Can anyone confirmed the best way to handle this so that even if we get an expected 404, that we can handle it in a way that it looks like the flow has run successfully?
Hi @danielbazetto,
I have ended up putting a counter in that increases a variable on a failure. Once the foreach finishes running, I then do a check to see if the counter is higher than 0 and fire a terminate outside the foreach. This still then shows the flow itself as being successful, albeit with 'Failed' steps in it.
Please do let me know if there is another way of dealing with this.
Thanks
James
Hi @Anonymous ,
I found your idea of handling it really good, I am not sure how differently we could handle that scenario.
Lets wait for someone else input here but meanwhile let me ask around to some colleagues of mine about any other suggestion.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
