Answered

Filtered Gallery to one long string

(0) Share

Report

Posted on by jimi_hendrix

Say I have a filtered gallery (Name: MyGallery) and it looks like this..

	Good / Bad	Name	Address	Blah
Item 1	Good	123	456	789
Item 43	Bad	abc	def	ghi
Item 56	Good	jkl	mno	pqr

I would like to simply have a two strings saying this:

Good

- Item 1 - 123 - 456 - 789

- Item 56 - jkl - mno - pqr

Bad

- Item 43 - abc - def - ghi

Im able to get columns of info through concat function but not understanding how to combine each row.. forall or something similar seems to be the right way of doing this but Im not having any luck

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

BCBuizer 22,422 Super User 2025 Season 2 on at

Like (0)

Report
Re: Filtered Gallery to one long string

Hi @jimi_hendrix ,

The easiest way is to use the AddColumns function with string interpolation:

AddColumns( DataSource, "LongString", $"{Title} - {Name} - {Address} - {Blah}" )

This adds a column (LongString) to each item (=row) that has the values of the mentioned columns in a combined string. If you then replace the data source code in your Concat function with this and have it reference the "LongString" column, you should get the result you are looking for.

Was this reply helpful? Yes No
jimi_hendrix on at

Like (0)

Report

Re: Filtered Gallery to one long string

@BCBuizer ,
This definitely sounds like the shortest putt to get whats needed. I do have some follow-up questions though.

Where is the best place to put this command? I would like to have this function occur in the background all the time. Ive temporarily put in into the OnSelect field for a random button during troubleshooting but it throws an error of "invalid argument type"

Never saw the use of the '$' before.. what does that allow you to do?

Was this reply helpful? Yes No
jimi_hendrix on at

Like (0)

Report

Re: Filtered Gallery to one long string

So messing with this some more.. I changed the datasource from a filtered gallery (which is what I want), to the overall data source.. now it doesnt throw the error any longer but cant seem to find the newly added column..

Was this reply helpful? Yes No
jimi_hendrix on at

Like (1)

Report

Re: Filtered Gallery to one long string

Thanks for your help.. Got it all figured out.. Put the AddColumn in the Items of the filtered gallery and then as you said concat the added column in the label

And as far as the '$', never saw this but removing it provides the title of column and not the contents of the column..

All good.. have a good rest of the day!

Was this reply helpful? Yes No
BCBuizer 22,422 Super User 2025 Season 2 on at

Like (0)

Report

Re: Filtered Gallery to one long string

Hi @jimi_hendrix ,

The $ allows for string interpolation, making it easier to combine static and dynamic strings.

https://powerapps.microsoft.com/en-us/blog/power-fx-string-interpolation-index-function-and-randbetween-function/

Was this reply helpful? Yes No