Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Is there a way to grab the error returned by a Flow action as dynamic content so I can send it in an email?

I have a Flow that pulls data from an excel file and then attempts to import the fields individually from that file into a CDS record. The reason I do it individually is because the excel file and cds both have nearly 200 fields so it would be hard to tell which field caused the error if I just attempt to import all fields at once. Right now I do have a system that works through the use of multiple Flows. Each Flow will check for 10 fields, but of course this will make it so I'll end up with 20 Flows which doesn't sound the best to me.


So essentially the flow will attempt an 'Update a CDS record' action but for just one field and I catch if it fails and then store that into a another cds record for the other flows to use and they all basically add onto that "error" record and the final Flow will use that to email the failed/invalid fields.


But when the action to update a cds record does fail, it does return an error that specifies which field was invalid. If I could somehow grab hold of that in Flow in the form of dynamic content, I could just use that instead and it simplify things a lot.


Thank you.


Helpful resources

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (53,191)