Unanswered

Flow to Add Form Response to New Event Details

(0) Share

Report

Posted on by meghannnnnn8

I have a flow set up to take responses from a Form and convert them into a new event on a shared calendar. I have it working great with the exception of one data piece. I have a multiple choice question on the form for the user to select attendees for the event. I have tried to set the multiple choice options to the users emails as well as just their names, but I keep running into this error:

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_event_(V4)' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/requiredAttendees' is required to be of type 'String/email'. The runtime value '"[\"Test Attendee\"]"' to be converted doesn't have the expected format 'string/email'.

I assume the culprit is the "[\" at the beginning of the response and the \"]" at the end, but I'm not sure how to get rid of that. I'm very new to Power Automate so any feedback would be greatly appreciated!

Below is a screenshot of my flow. The Required Attendees field is the only thing giving me trouble. If I remove that response detail it works perfectly.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello,

you can remove the brackets by applying the json(...) expression on the response, that'll convert from string (what you see now with the escape characters) into an array. I'd guess that the required attendees expect a semicolon separated email addresses - if that's the case use the join(...) expression to turn it from an array into a string, e.g.

join(json(<theResponse>),';')

Was this reply helpful? Yes No
meghannnnnn8 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Tom,

Thank you for your response. Unfortunately, I am a real novice here. I took a semester of Python in college but my programming skills are overall lacking! Would you maybe be able to break down your response for me a bit more? I tried reading the link you provided but I fear I'm still a bit confused on the execution within my specific example.

Was this reply helpful? Yes No