Flow Save Fail error ('OpenApiOperationParameterValidationFailed')

[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:

[FLMike]

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

[PLUMPZ]

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

[FLMike]

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

[PLUMPZ]

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"}}

[PLUMPZ]

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?

[ManishSolanki]

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

[FLMike]

Yeah thats what i told them originally

[FLMike]

@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