Unanswered

Combine Concat and LookUp in PowerApps

(0) Share

Report

Posted on by Community Power Pla...

Hi experts. I have a PowerApps form that has a conncetion to a SharePoint list called "**bleep**systemer". The list has two fields, Titel and Mail

In my PowerApps form I have a Combobox that the user can choose several items from. I want to be able to get the mail from each choosen value in the Combobox, but no matter how hard I try, I cannot get it to work. I have thede threee fields:

The fields have the following codes:

Combobox (field one)
SortByColumns(**bleep**systemer.Titel;"Title")

Results of choosen values in combobox (field two)
Concat(ComboBox1.SelectedItems;Titel;", ")

Get the mails that is associated to the Titel field (field three)
LookUp(**bleep**systemer;Titel = ComboBox1.Selected.Titel;Mail)

I know I have to combine the LookUp and Concat functions, but no matter how I do it, it only returns the last choise in the Combobox, or I get an syntax error. Can anyone in this forum, guide me how to get the value from the mail collum, from the choosen values in the Combobox?

THX in advance

Greetings from Denmark

Frank Nielsen

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

PavanKumar 479 on at

Like (0)

Report
Hi Frank,

Once can you try this and let me know if its working.

Concat(ComboBox1.SelectedItems, Value&",") or Concat(ComboBox1.SelectedItems, Mail&",")

Mark it as verified if it answers your question
Regards,
Pavan Kumar Garlapati

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hey,

If i understand it correctly you want to get all emails from the chosen values. What needs to be done is to use something like:

ForAll(ComboBox1.SelectedItems, Contact(LookUp(**bleep**systemer;Titel = ComboBox1.Selected.Titel;Mail), ","))

Hope this helps.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hey @Anonymous

Since you are allowing multiple selections you can use the formula on the third field as:

Concat(Filter(**bleep**systemer;Titel in ComboBox1.Selected.Titel);Mail;", ")

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @yashag2255 I have tried your solution, but failed 😞
I get some results, but not what i have expected. Maybe i do something wrong. The mail adress field returns all mails as you can see on thsi picutre, and if i choose a value in the combobox the mail adress retuens zero.

Maybee it´s because i do not know what you are refering to with "Titel in ComboBox1".Selected.Titel.

/Frank

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @PavanKumar I have tried your solution bit it have failed. i think I need some kind of lookup also. If I use your suggestion I get this:
I think it´s because I do not have a lookup to the SharePoint list in the code, and PowerApps is only returning the Mail function from the Office 365 User connection.

/Frank

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Anonymous. When I try your solution I get this error:

The property of this widget expects text values. The rule produces table values that are incompatible

I have tried to search for a solution to this, but I am not able to find anything helpfull.

/Frank

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (3)

Report

Hi @Anonymous

Can you try to update your formula as:

Concat(Filter(**bleep**systemer;Titel in ComboBox1.SelectedItems.Titel);Mail;", ")

Explanation: "Titel in ComboBox1".SelectedItems.Titel

FIlter returns a number of records satisfying the condition and using the In operator we are checking for those records which have the title value present in the combobox selected Title. While, ComboBox1.SelectedItems.Titel returns a list of all the titles selected in the combobox control.

I carried out a test on my side and this was getting me the results:

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

WOW - @yashag2255 you are GOD

This has med the day for me.

THX a thousand times. I bow to you.

/Frank
Denmark

Was this reply helpful? Yes No
sajidali08 3 on at

Like (0)

Report

That's awesome solution and perfectly working. Thank You

Was this reply helpful? Yes No