cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kdurgp8
Frequent Visitor

Concat for multiple selections in a listbox

Hey all, 
I see that many people have asked similar questions around getting the selection in a listbox. I have a list that is pulling from Sharepoint and displaying the "Title" field. I would like to concat all the selected items into a string so that I can later send them into an Automate Flow. I feel that I am close, but I am missing something. 

In this screenshot, I can see that I have 3 values when I hover over the "Title" in Line 1. 

kdurgp8_0-1635885744831.png


But when I hover below on the variable name, it shows the value is "Blank".  

kdurgp8_1-1635885805767.png


... And to prove that the data isn't storing and submitting, here is a screenshot in Power Automate showing the payload:

kdurgp8_0-1635886259789.png



Any Ideas? Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
kdurgp8
Frequent Visitor

Like many others, I was able to solve this. My solution was:

Set(selectedSites, Concat(ListBox_Sites.SelectedItemsText.Title, Concatenate(Text(Title),",")));


Resource:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Concat-Multiselect-Listbox-expression-error/...

View solution in original post

1 REPLY 1
kdurgp8
Frequent Visitor

Like many others, I was able to solve this. My solution was:

Set(selectedSites, Concat(ListBox_Sites.SelectedItemsText.Title, Concatenate(Text(Title),",")));


Resource:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Concat-Multiselect-Listbox-expression-error/...

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,238)