cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
venseben
Level: Powered On

Combine Concat and LookUp in PowerApps

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:ComboboxLookUp.PNG

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

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Combine Concat and LookUp in PowerApps

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:MicrosoftTeams-image (20).png

 

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!

View solution in original post

8 REPLIES 8
PavanKumar
Level 8

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

lucia
Level 8

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.

Dual Super User
Dual Super User

Re: Combine Concat and LookUp in PowerApps

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
Level: Powered On

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.yashag2255.PNG

 

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

 

/Frank

venseben
Level: Powered On

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:pavankumar.PNG

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
Level: Powered On

Re: Combine Concat and LookUp in PowerApps

Hi @lucia. 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

Dual Super User
Dual Super User

Re: Combine Concat and LookUp in PowerApps

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:MicrosoftTeams-image (20).png

 

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!

View solution in original post

venseben
Level: Powered On

Re: Combine Concat and LookUp in PowerApps

WOW - @yashag2255 you are GOD Smiley Happy

 

This has med the day for me.

 

THX a thousand times.  I bow to you.

 

/Frank

Denmark

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,435)