cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Showing Choices in a Text Field from a Multi Choice Lookup Field

I would like to be able to show all of my multiple choices, from a SharePoint list lookup column, in a text label in my PowerApp?  My efforts have not worked.  The attached image explains the problem.  

 

Thank you in advance for your help. 

 

Cindy 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Showing Choices in a Text Field from a Multi Choice Lookup Field

@CindyZ 

Put this in your label

Left( 
      Concat(ThisItem.MultiChoiceLookUp, Value & ", "),
             Len(Concat(ThisItem.MultiChoiceLookUp, Value & ", ")
      )-2
)

 

 

View solution in original post

Highlighted
Super User III
Super User III

Re: Showing Choices in a Text Field from a Multi Choice Lookup Field

@CindyZ 

This code will display all your choices in a text field.

 

Concat(ThisItem.MultiChoiceLookup, Value & ", ")

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

6 REPLIES 6
Highlighted
Super User II
Super User II

Re: Showing Choices in a Text Field from a Multi Choice Lookup Field

@CindyZ 

Put this in your label

Left( 
      Concat(ThisItem.MultiChoiceLookUp, Value & ", "),
             Len(Concat(ThisItem.MultiChoiceLookUp, Value & ", ")
      )-2
)

 

 

View solution in original post

Highlighted
Super User III
Super User III

Re: Showing Choices in a Text Field from a Multi Choice Lookup Field

@CindyZ 

This code will display all your choices in a text field.

 

Concat(ThisItem.MultiChoiceLookup, Value & ", ")

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Highlighted
Post Patron
Post Patron

Re: Showing Choices in a Text Field from a Multi Choice Lookup Field

@Eelman Thanks ever so much for your immediate help!  I never dreamed I'd get this finished on Friday OR it would have involved Concat and not Add Columns--thought that was where I had to go.  

Also, would you please explain what you are doing with the "Len and -2.  @mdevaney 's solution worked equally as well, except it did leave me with a comma at the end -- which I was going to check on until I tried your formula and that was resolved.  I'd like to understand that better.

 

Again, my sincerest thanks to both you and @mdevaney!  

Highlighted
Post Patron
Post Patron

Re: Showing Choices in a Text Field from a Multi Choice Lookup Field

Everything I said to @Eelman !  Truly appreciate your jumping right in to help!  Don't have a clue how I'd have progressed with PowerApps with the support of others!  

 

 

Highlighted
Super User II
Super User II

Re: Showing Choices in a Text Field from a Multi Choice Lookup Field

@CindyZ 

No worries, happy to help.

 

The Len() and Left() formula's just strip away the trailing ", " that gets added by Concat(). If you are familiar with the use of these formulas in Excel then they are working the same here. If not, this may help

 

Left() starts on the LHS of a text string and returns the number of characters that you specify, eg

Left("Text String", 4) = "Text"
Left("Text String", 8 )= "Text Str")

 

And Len() returns the number of characters in a string, eg

Len("Text String") = 11

 

So when we combine them together we can do this

Left( "Text String", Len("Text String") - 3) = "Text Str", because Len("Text String") - 3 = 8

 

In the above formulas we know exactly how long "Text String" is because it is always the same length ie 11. However, with your MultiChoiceLookUp data the length is unknown for each record so we use the length of each record and minus 2 for ", ".

 

Hope this makes sense 🙂 

Highlighted
Post Patron
Post Patron

Re: Showing Choices in a Text Field from a Multi Choice Lookup Field

Makes perfect sense.  Thanks for taking the time to provide such a detailed explanation.  

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,844)