web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Trying to Concatenate ...

Power Apps

Answered

Trying to Concatenate the results from two Concats on multiple choice fields from sharepoint list.

(0) Share

Report

Report

Posted on by Faulknerjam

3

Hello all,

I am new to Power Apps and have been watching a lot of videos on how to build my app. Here is what I am trying to accomplish.

I have a gallery, and I have a label where I want to combine the text from two different multiple choice columns from a sharepoint list. So far I have been able to Concat the values from one column by entering the following fx:

Concat(ThisItem.AV, Thisrecord.Value, ", ")

Any help will be greatly appreciated.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Concat returns table value. If I am understanding you correctly you will have two separate concants and want to merge them together into one table?

You can acheive this with a ClearCollect() and AddColumns().

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
Subscribe to my YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Verified answer

WarrenBelz 156,530 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Faulknerjam ,

Assuming you want them in a Label in the gallery with commas in between

Concat( ThisItem.Field1Name, Value & "," ) & Concat( ThisItem.Field2Name, Value & "," )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Join the conversation