web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps display mails from sha...

Power Apps

Answered

display mails from sharepoint to combo box based on certain condition

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

So previously I have a combo box that is taking item from a sharepoint list name customerDetails. For that I put customerDetails.Mail in the item properties of the combo box but now i want to display mail of customer that are in a specific team only (team is already define in sharepoint list) e.g. suppose - i want to display mails of those customer who is in HR department (team="HR") Only

How to do that?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @valavbs,

Could you please tell me that what is the column type of the Mail and Team? Both Text type or Mail is a Person, Teams is a Text?

Filter(customerDetails, team="HR").Mail

If Mail is Person, please use as below:

ForAll(Filter(customerDetails, team="HR"),Mail.Email)

Join the conversation