Unanswered

Using Office365Users to get the email of multiple names taken from a multiselected list box

(0) Share

Report

Posted on by BethHarding

I have built an app that takes conditions submitted by a user and suggests contact for them to get support from, they then choose the resource they want in a list box (multiple selection allowed) and I want to use the information selected in this and pull through those peoples emails from office365users for the user to send an automated email.

Where there are multiple options selected I tried the forall function which obviously won't work when searching for users in office365users are it's multiple people.

How can I cycle through the selected resources and return the emails of them, instead of it using all?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @BethHarding ,

I've made a test for your reference:

1\I assume there is a combobox(ComboBox1) and it's items property is :

["bof","alex","adel"]

2\You could try this formula to get mails split by ';'

Concat( ForAll( ComboBox1.SelectedItems, First(Office365Users.SearchUser({searchTerm:Value})).Mail ),Value,";")

Best Regards,

Bof

Was this reply helpful? Yes No
BethHarding on at

Like (0)

Report
Copy link

Link copied!

The input is a list box:

When I use for all and concat to get the output it reads :

I want to then take these names, all that have been selected, and get the email address (using office365users) of each to send an email requesting support.

Was this reply helpful? Yes No