Adding respondent from form to Outlook invite

(0) Share

Report

Posted on by Amapola188

294

I'm trying to follow Tom Riha's method to add form respondents to an Outlook invite but I can't get it to work.

https://tomriha.com/use-power-automate-to-forward-outlook-events-upon-registration/

{
 "attendees": [{"emailAddress":"{\"address\":\"xxx@xxx.com\"}"},{"emailAddress":{"address":"xxx@xxx.com"}}]
}

This is what it looks like for the body of the HTTP action and I seem to get double quotes before the curly brackets for the array - which aren't in the instructions for it. - Are those double quotes the problem? And if so, what can I do about them?

Thanks for any pointers.

Christine

All responses (2)

Answers (1)

Amapola188 294 on at

Like (0)

Report

Re: Adding respondent from form to Outlook invite

Slightly different approach, but this worked and I'm posting the entire solution here. I'm deviating from the original, starting with a filter action because the existing attendees come through with an empty record which I want to take out.

The From split expression is:
split(outputs('Get_event_(V3)')?['body/requiredAttendees'],';')
and the filter is: @equals(empty(item()),false)

From is Filter output
emailAddress is {"address":"@{item()}"}

This is where I used Wearsky's suggestion:
json(replace(replace(replace(string(body('Select')),'"{','{'),'}"','}'),'\"','"'))

{
"emailAddress": {
"address": "@{outputs('Get_response_details')?['body/responder']}"
}
}

{
"attendees": @{variables('varAttendees')}
}

Thanks, @v-xiaochen-msft, works like a dream now!
Verified answer

v-xiaochen-msft on at

Like (1)

Report

Re: Adding respondent from form to Outlook invite

Hi @Amapola188 ,

Please try this

json(replace(replace(replace(string(variables('var')),'"{','{'),'}"','}'),'\"','"'))

Best Regards,

Wearsky