Unanswered

Drop down gallery

(1) Share

Report

Posted on by CU11082038-3

I need help, I have a gallery in which I create buttons based on data from Sharepoint.
It works great for me on one procedure and when I wanted to implement it here and there it doesn't work for me and I don't know where the error could be.
And the only thing that changes there is the column in sharepoint which is defined as multiple choise

GroupBy(
    SortByColumns(
        Filter(
            AddColumns(
                'Best Practice Ideas';
                'New colum';
                'Inter-cluster Sharing paint shop cluster'.Value
            );
            Not(IsBlank('New colum'))
        );
        "New colum";
        SortOrder.Ascending
    );
    'New colum';
    Data
)
 
Here is that collumn in sharepoint 
 
 
 
Any help would be appreciated, I can't move anymore
 

Categories:

Building Power Apps

Snímka obrazovky ...

I have the same question (0)

All responses (5)

Answers (0)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Which one is multichoice, 'Inter-cluster??????

If you do a ClearCollect, to a random collection for testing, do you see the values?

Also, why are you doing the AddColumns, before the filter hits?

Was this reply helpful? Yes No
CU11082038-3 on at

Like (0)

Report

Yes that inter cluster is multiple choice.

What you mean ClearCollect ?

thanks for your answer :)

Was this reply helpful? Yes No
CU11082038-3 on at

Like (0)

Report

this code works almost fine, only we don't split the values in that given row.

For example, if I have Maintenance and Logistics there, it merges them into one, and I would need them to be divided separately,

that one button Maintenance and the other Logistics

GroupBy(

SortByColumns(

AddColumns(

Filter(

'Best Practice Ideas';

Cluster.Value = "Paint shop cluster"

);

'New colum';

Concat('Inter-cluster Sharing';Value; ";")

);

"New colum";

SortOrder.Ascending

);

'New colum';

Data

)

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
did u make sure to copy your whole code snippet? it looks cut off, or am i wrong?

if its not cut off can u give this a try:
GroupBy( SortByColumns( Filter( AddColumns( 'Best Practice Ideas', 'NewColumn', Concat(ThisItem.'Inter-cluster Sharing paint shop cluster'.Value, ", ") ), Not(IsBlank('NewColumn')) ), "NewColumn", SortOrder.Ascending ), 'NewColumn', "Data" )
if the Post help you solve your issue, please mark it as verified answer and give it a like so we can help other in the community with similar issues

Greetings

Was this reply helpful? Yes No
CU11082038-3 on at

Like (0)

Report

Hi mmbr1606

My code is all copied

And unfortunately yours doesn't work for me :(

Was this reply helpful? Yes No