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:

General Questions

Snímka obrazovky ...

All responses (5)

Answers (0)

CU11082038-3 on at

Like (0)

Report

Drop down gallery

Hi mmbr1606

My code is all copied

And unfortunately yours doesn't work for me :(
mmbr1606 12,108 Super User 2025 Season 1 on at

Like (0)

Report
Drop down gallery

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
CU11082038-3 on at

Like (0)

Report

Drop down gallery

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

)
CU11082038-3 on at

Like (0)

Report

Drop down gallery

Yes that inter cluster is multiple choice.

What you mean ClearCollect ?

thanks for your answer :)
Michael E. Gernaey 41,027 Super User 2025 Season 1 on at

Like (0)

Report

Drop down gallery

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?