Addcolumn in Filtered Combobox

(0) Share

Report

Posted on by Synavian

Hello everyone! I am quite new to Powerapps and struggled with Adding a new column to Combobox Results values.

I have the following code and it works perfectly with two connected Databases (Crewing and Beneficiary) :

Filter(
Choices(Crewing.Name);
Value in Filter(
AddColumns(Beneficiary; "Activity"; UserType.Value);
Activity = "Seaman"
).Name
)

The output shows two Columns: Filtered seaman`s Id (which is the default) and his Name (as the Value).

However, what I actually want to achieve is also to get Filtered seaman`s Email (as a third row). I am planning to use a Double layout for Combobox where the Filtered seaman`s Name will be the Primary and his Email will be the Secondary text.

Your assistance will be highly appreciated!

P.S. UserType is a Choice Type column.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Synavian,

Is email a text field in the Beneficiary table or where can we get this?

//Example should the Name field be a LookUp to the Beneficiary list AddColumns( Filter( Choices(Crewing.Name); Value in Filter( AddColumns(Beneficiary; "Activity"; UserType.Value); Activity = "Seaman" ).Name ), "Email", LookUp(Beneficiary, Id = ID).Email )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
Synavian 7 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes, Email is the Text field. It works Great! Thank you!