Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Flow to Add Form Response to New Event Details

(0) ShareShare
ReportReport
Posted on by 12
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. 
  • meghannnnnn8 Profile Picture
    12 on at
    Flow to Add Form Response to New Event Details
    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. 
  • tom_riha Profile Picture
    10,127 Most Valuable Professional on at
    Flow to Add Form Response to New Event Details
    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>),';')

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >