Combine Concat and LookUp in PowerApps

[venseben]

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

[PavanKumar]

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

[Anonymous]

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.

[yashag2255]

Hey @venseben 

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!

[venseben]

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

[venseben]

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

[venseben]

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

[yashag2255 · Accepted solution]

Hi @venseben 

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!

[venseben]

WOW - @yashag2255 you are GOD 

This has med the day for me.

THX a thousand times.  I bow to you.

/Frank

Denmark

[sajidali08]

That's awesome solution and perfectly working. Thank You