cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Create (only one) calendar entry from a sharepoint list

Hello everyone,

 

I have a SPO List with a "Employees" field (with is a person field with multiple selections). When someone creates or modifies an element in the list, a Flow creates a Calendar event (outlook connector, create an event V2). This works fine so far.

But: I would like to have the employees selected in the SPO person list field as required attendees in the event. When I use the field "required attendees" and click on "dynamic content -> when an item is... -> eyployees Email"

then Flow builds automaticaly a foreach container around my "create an event V2". That means, that for every person in the employees field a new calender entry is made. I have no Idea how to change that or how to build the flow otherwise. Have some of you?

 

Thanks for your help!

 

greets,

Mars

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @Mars_faces,

 

You could use variables to store all person's emails and then configure the variables in the "attendees" field.

  1. First Initialize a variable of type String.
  2. Use Apply_to_each to traverse the information of the person contained in the column, add the email to the string variable, and end with a semicolon.
  3. Finally, the variables are configured in the "attendees" field.

Image reference:

7.PNG

Run history:

8.PNG

Please take a try.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support
Community Support

Hi @Mars_faces,

 

You could use variables to store all person's emails and then configure the variables in the "attendees" field.

  1. First Initialize a variable of type String.
  2. Use Apply_to_each to traverse the information of the person contained in the column, add the email to the string variable, and end with a semicolon.
  3. Finally, the variables are configured in the "attendees" field.

Image reference:

7.PNG

Run history:

8.PNG

Please take a try.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @v-bacao-msft,

 

Thank you for your help! It works fine now.

 

Best regards,

Mars

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (3,509)