Adding respondent from form to Outlook invite

Like (0) Share

Report

Posted on 17 May 2024 01:12:15 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

I have the same question (0)

All responses (2)

Answers (1)

Amapola188 294 on 17 May 2024 at 07:20:41

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!

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on 17 May 2024 at 06:53:11

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

Was this reply helpful? Yes No