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
 

Snímka obrazovky 2024-07-23 085646ddd.png

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

Hi mmbr1606

My code is all copied

And unfortunately yours doesn't work for me :(

Was this reply helpful? Yes No