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)
Results of choosen values in combobox (field two)
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
Solved! Go to Solution.
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
Pavan Kumar Garlapati
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.
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.
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.
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.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications