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

Is there a way to validate each field out of a hundred in order to know exactly which ones were invalid?

I have a Flow that triggers when a user drops an excel file into a SharePoint library. Once that happens, the Flow will use the data in the excel to create new cds record.

 

createrecord.png

What I have at the moment is we attempt to create the record and if this fails I send out an email. The issue with this however is we can't single out which fields caused the error.

 

What I am trying to do is basically try to use the create and update a cds record actions for every single field and then catching that. The only issue is that I have over a hundred fields to do this for and I don't think doing that in Flow will be very good since I'll end up with a hundred actions which I've never done before in Flow and am not even sure can be done. 

 

So this is my current attempt:

 

specificcreate.png

 

This is just for two fields. So for the first one, I try to create the cds record with 'Name', and then the second one I update that same record with the 'Test Currency Column 1' field. And if each fails then I'll add that to a string which will be sent in an email.

Is there another way to do this? Does anybody have any tips on how to do this? I've been thinking of having this Flow call another Flow in order to split up the work between Flows.

 

Another thing I'm wondering is if there is a way to get the error message returned by a failed action and send that in an email or store it into a variable? So when the action fails, I catch it and then get the error message. Is that possible? 

 

Thank you.

 

 

 

2 REPLIES 2
Dual Super User II
Dual Super User II

Hi @Mgodby 

 

This would be a huge number of API calls to the CDS just for one record. I would recommend you add validations in the Excel itself before attempting to create the record in CDS. 

 

You can also get the row from excel and add those validations in Power Automate and then create a table with the ones that do not match and send an email to the person regarding that. 

 

Lastly, the create/ update record when fail, you can access the error message and it returns the first column value at which it failed and maybe you can map it out from there. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

"Lastly, the create/ update record when fail, you can access the error message and it returns the first column value at which it failed and maybe you can map it out from there. "

 

Is there dynamic content for this? If I can do this then basically solves all my problems. When my flow does fail it gives a more precise error but my only issue is not being able to grab that. If I could then I could simply use that for the error message in my email. 

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

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 (8,161)