Accessing Custom Fields From MS Bookings

(0) Share

Report

Posted on by ML-09011203-0

Hi All

I'm having a problem with getting the response from a Bookings variable into an email using Power Automate. I've tried everything and don't seem to be getting anywhere.

I've managed to filter the array down and I can see the value I need but unable to add this to the email Subject/Body:

Is what I'm trying to do actually possible and if so can anyone point me in the right direction?

Thanks for reading.

Mick

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Kalathiya 2,249 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @ML-09011203-0,

Please try below approach:

Use a Compose action after your filter to isolate the value:

formula with your action name:

body('Get_The_Company_Name_From_Array')?['body']?[0]?['Company'] // replace "body('Get_The_Company_Name_From_Array')" this name with your actual filter action name if it's wrong

If it's worked, please mark this as the Verified Answer so others can benefit from the fix.

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping.

Was this reply helpful? Yes No
ML-09011616-0 4 on at

Like (0)

Report
Copy link

Link copied!

@Kalathiya I've just tried this but get the following error:

Action 'Compose' failed: Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language expression 'body('Get_The_Company_Name_From_Array')?['body']?[0]?['Company']' cannot be evaluated because property 'body' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

any ideas?

Thanks

Mick

Was this reply helpful? Yes No
ML-09011616-0 4 on at

Like (0)

Report
Copy link

Link copied!

@kalathiya got it working, the work code is:

body('Get_The_Company_Name_From_Array')?[0]?['Company']

Thanks for you help.

Mick

Was this reply helpful? Yes No