Concat for Gallery

[StephenGW]

I have a SP list with 5 columns Sort Findings 1, 2, 3, ect that I want to join into one gallery and then split into separate gallery items. First I filtered the data source to only get the item I want. Then I tried to join them all together and split but it's giving me an error on the Concat of "Invalid argument type. Expecting one of the following: Text, Number, Date, ect" and "Unexpected characters, characters are used in the formula in an unexpected way." The columns of data in the SP list are multi line text and only separated by a comma.

Filter(
       Split(
             Concat(
                     Filter('List Name', ID = 2),
                     If(!IsBlank('Sort Findings 1'), 'Sort Findings 1', Blank()) & "," &
                     If(!IsBlank('Sort Findings 2'), 'Sort Findings 2', Blank()) & "," &
                     If(!IsBlank('Sort Findings 3'), 'Sort Findings 3', Blank()) & "," &
                     If(!IsBlank('Sort Findings 4'), 'Sort Findings 4', Blank()) & "," &
                     If(!IsBlank('Sort Findings 5'), 'Sort Findings 5', Blank()) & "," &
                  ),
             ","
       ),
       !IsBlank(Result)
)

Anybody have any ideas why this is happening? I have used a similar formula in a different app with no problems. Is it the multi line? What can I do differently?

Thanks

[RandyHayes · Accepted solution]

@StephenGW 

You have an extra ampersand than you need.  Formula should be changed to the following:

Filter(
       Split(
             Concat(
                     Filter('List Name', ID = 2),
                     'Sort Findings 1' & "," &
                     'Sort Findings 2' & "," &
                     'Sort Findings 3' & "," &
                     'Sort Findings 4' & "," &
                     'Sort Findings 5'
                  ),
             ","
       ),
       !IsBlank(Result)
)

You don't need the If statements!  You are checking to see if something is Blank and if it is, then you are returning a Blank....well, it already is blank!!  So the above will yield the same results without all the extra typing.

I hope this is helpful for you.

[StephenGW]

@RandyHayes 

Thank you! I starred at it for 30 minutes probably and didn't even notice the extra ampersand! Bonus you shortened it for me too!