Email of Person Column in SharePoint Does Not Appear in Power Automate Dynamic Value

(1) Share

Report

Posted on by third_learner

115

Hi,

Asking for your help regarding my flow. I want to add the 'Business Partner' email dynamic value to Select action but it does not appear/ missing in the list. In my SharePoint list, the column type of 'Business Partner' is Person or Group.

Is there anyway to make the email of 'Business Partner' appear in the dynamic value?

Thank you for your help

Categories:

General topics

All responses (8)

Answers (3)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @third_learner ,

If the person column is multi-select, you need to put each person column's value as an array in From field. Then use expression to extract all emails.

Best regards,

Rimmon
third_learner 115 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v-mengmli-msft

I tried it before but I am getting null values for the person's email. Not sure why.
v-mengmli-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @third_learner ,

What are you using in From field?

Please check your Select action according to my.

Best regards,

Rimmon
third_learner 115 on at

Like
a
(1)

Report
Copy link

Link copied!

@v-mengmli-msft

I am using 'value' from the Get Items action in From.
Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @third_learner ,

It should be multi-select person column.

Best regards,

Rimmon
third_learner 115 on at

Like
a
(1)

Report
Copy link

Link copied!

@v-mengmli-msft
Do you mean I need to change the column type of Business Partner from 'Person or Group' to 'Multi-select'?
This is the current setting of the column.
Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @third_learner ,

It is already multi-select.

I mean you need to select "Business Partner" dynamic content in From field.

Best regards,

Rimmon
third_learner 115 on at

Like
a
(1)

Report
Copy link

Link copied!

@v-mengmli-msft

Thank you very much for your help. It works now.