Unanswered

Flow Save Fail error ('OpenApiOperationParameterValidationFailed')

(0) Share

Report

Posted on by PLUMPZ

Good day all,

I am currently trying to set up a Flow to send out reminders via Send Email(V2) to users within a list in SharePoint. While the initial test has succeeded, when changing the list to a different Namelist, I am confronted with the below error:

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'emailMessage' validation failed in workflow operation 'Send_an_email_(V2)_2': The parameter with value '"@items('Apply_to_each_2')?['field_2']"' in path 'emailMessage/To' with type/format 'Number/double' is not convertible to type/format 'String/email'.'.

I am unsure why this happens. I will also attach a snapshot of the flow.

If anyone has any resolutions, I would be happy to hear them as I am baffled as to why one list functions and another does not.

The only differing factor being that one list was create within SharePoint (The successful run list) and the other (The failed run list) was imported from excel.

Snapshot:

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @PLUMPZ

Thank you for sharing the flow. In this case you need to share the data. YOu should go to the Flow that failed and look at its history.

Get the error.

Flip through the Apply to each (which you can do in the History run) and when you get to the one that failed, show us the Input and output, because the error clearly says the value cannot be converted to an email.

So the issue is with the data.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
PLUMPZ 22 on at

Like (0)

Report
Copy link

Link copied!

Hi @FLMike

Thanks for the quizk response, unfortunately as the save flow failed I am unable to test run the flow nor am I able to save the flow in which case, would like to ask if there are other methods in obtaining the error as I would have to revert to the old list (The one which ran successfully) in order to save

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @PLUMPZ

not sure I follow. What I asked you to do was go to the History of the flow, where you should see any run (failed or not).

Are you saying you dont see any in the History

Go to the Details Page
Go to the Bottom of the page
You see the history
Click on a run that failed
Grab the data per my ask above

Are you saying you cannot do that? and if not where did the runs go?

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
PLUMPZ 22 on at

Like (0)

Report
Copy link

Link copied!
Hi @FLMike

This would be the screenshot of the data you've requested

When clicking onto the outputs, this would be the error received:
{"statusCode":200,"headers":{"Cache-Control":"no-store, no-cache","Pragma":"no-cache","Set-Cookie":"ARRAffinity=1bf1fa7ef58a2ee2d7a44c3046cbe5c763c69a7c47c896aacbb04ba8a00ffc3b;Path=/;HttpOnly;Secure;Domain=office365-ea.azconn-ea-001.p.azurewebsites.net,ARRAffinitySameSite=1bf1fa7ef58a2ee2d7a44c3046cbe5c763c69a7c47c896aacbb04ba8a00ffc3b;Path=/;HttpOnly;SameSite=None;Secure;Domain=office365-ea.azconn-ea-001.p.azurewebsites.net","Strict-Transport-Security":"max-age=31536000; includeSubDomains","x-ms-request-id":"cf50e25e-07c1-16f6-94ed-efbe4de78c31","X-Content-Type-Options":"nosniff","X-Frame-Options":"DENY","x-ms-environment-id":"default-74448caa-174e-465d-86f1-5d3c218512ef","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"false","x-ms-apihub-obo":"false","Date":"Fri, 27 Oct 2023 03:53:20 GMT","Content-Length":"0","Expires":"-1"}}

Was this reply helpful? Yes No
PLUMPZ 22 on at

Like (0)

Report
Copy link

Link copied!

Hi @FLMike

As an added, when linking to another list (The list that successfully ran the flow), the flow runs successfully)
The only differences betweent the two lists being the one that passes was created within SharePoint itself and the one that failed was imported from excel. Could this be an issue with how Excel handles the data?

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @PLUMPZ

Pls also check for email recipient value in the "Send an email" action which is there in "Apply to each 2" action. From the error, it looks like there is some problem in setting up the email recipient (To).

Thanks

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yeah thats what i told them originally

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

@PLUMPZ

You definitely have a data issue but I believe only from the perspective that your excel driven flow is pointing to the wrong column for Send To Email

If you look at my original response to your original post, your code is trying to convertThe parameter with value '"@items('Apply_to_each_2')?['field_2']"' in path 'emailMessage/To' with type/format 'Number/double' is not convertible to type/format 'String/email'.'

but now in that picture the error is that it was null

I believe you are setting the Email Send To column to the wrong column in Excel (aka mapping it wrong). So I dont think its a problem that its excel, its that you are pulling the wrong column.

Since in both cases it was a number or null, I think you are pointing to a number column, but at elast its not the Email Address column

please triple check that.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No