Answered

Combine Concat and LookUp in PowerApps

Like (0) Share

Report

Posted on 21 Aug 2019 13:10:24 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:

Connecting to Data

All responses (9)

Answers (1)

sajidali08 3 on 23 Mar 2021 at 14:04:48

Like (0)

Report

Re: Combine Concat and LookUp in PowerApps

That's awesome solution and perfectly working. Thank You
Community Power Pla... on 22 Aug 2019 at 08:05:37

Like (0)

Report

Re: Combine Concat and LookUp in PowerApps

WOW - @yashag2255 you are GOD

This has med the day for me.

THX a thousand times. I bow to you.

/Frank
Denmark
Verified answer

yashag2255 24,647 Super User 2024 Season 1 on 22 Aug 2019 at 07:21:58

Like (3)

Report

Re: Combine Concat and LookUp in PowerApps

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!
Community Power Pla... on 22 Aug 2019 at 07:09:28

Like (0)

Report

Re: Combine Concat and LookUp in PowerApps

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
Community Power Pla... on 22 Aug 2019 at 07:07:25

Like (0)

Report

Re: Combine Concat and LookUp in PowerApps

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
Community Power Pla... on 22 Aug 2019 at 07:04:37

Like (0)

Report

Re: Combine Concat and LookUp in PowerApps

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
yashag2255 24,647 Super User 2024 Season 1 on 21 Aug 2019 at 13:49:07

Like (0)

Report

Re: Combine Concat and LookUp in PowerApps

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!
Community Power Pla... on 21 Aug 2019 at 13:32:45

Like (0)

Report

Re: Combine Concat and LookUp in PowerApps

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.
PavanKumar 479 on 21 Aug 2019 at 13:28:24

Like (0)

Report
Re: Combine Concat and LookUp in PowerApps

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