Formatting Issue for Create Event (V4)

(0) Share

Report

Posted on by IG-07011853-0

Hello,

I'm currently working on a flow that will take an item from my source list and create a calendar event when the approval status changes to Approved. I've got the flow working and creating the event on my calendar as desired, however, in the body of the event, my installers line of data is showing up exactly as my Select step of the flow is spitting it out, rather than just the display names of my desired field. How can i modify my flow to reflect just the installers name without the extra {"Name":} characters? I suspect output of my Select step may be the issue, but I'm not sure how to modify it accordingly.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Expiscornovus 33,874 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @IG-07011853-0,

It looks like you used the key value mode in your Select action. Can you switch to text mode (one column in the map field) instead? You can use the t button on the right side for that.

With that mode you will just get your value. After that you can use an expression with a join function to turn the array values into one line of text with for example a comma as a separator in the body of your event.

Below is an example

join(body('Select'), ', ')

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No