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

[Faulknerjam]

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.

[phipps0218]

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

[WarrenBelz · Accepted solution]

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