0

I have a People/Group SharePoint field named "Person" which allow multiple selection >> and I am getting the related list items (which contain the "Person" field) using Get Items as follow:

enter image description here

Then inside the Select I want to select the Person email addresses to build a comma separated string for all the Person emails >> but I only get the Person property, as follow and did not get a property for the Person email:

enter image description here

So can anyone advice?

3
  • Try turning OFF experimental features and see if it is showing Person Email property in Select action: ganeshsanapblogs.wordpress.com/2020/12/11/… Commented Mar 24, 2023 at 5:51
  • @GaneshSanap what is the relationship between the two?
    – John John
    Commented Mar 24, 2023 at 21:48
  • With experimental features turned ON, you have different user experience. For example in your images, "Filter query" is easy to add by selecting options from drop down but you don't see Person Email field in Select. In case you turn OFF the feature, you have to write your own filter query without drop down options and you will get Person Email field to use in Select action. Commented Mar 25, 2023 at 3:00

1 Answer 1

1

Try this:

  1. Select Person in From property of Select action

  2. Use expression like below in Map property of Select action

item()['Email']

Action:

enter image description here

Output:

enter image description here


You can also check my answer on this thread for different approach to achieve the same requirements to collect email addresses: How to get email and send Email To Multiple Values In People Picker Field In SharePoint

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.