Unanswered

Drop down gallery

(1) Share

Report

Posted on by AndrejPavlik18

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 Choice

GroupBy(

SortByColumns(

AddColumns(

'Best Practice Ideas',

'New colum',

'Inter-cluster Sharing'.Value

"New colum",

SortOrder.Ascending

'New colum',

Data

)

Here is an example where it works for me, the data source is the same, only the column in excel changes

GroupBy(

SortByColumns(

AddColumns(

'Best Practice Ideas',

'New colum',

'Sub process'.Value

"New colum",

SortOrder.Ascending

'New colum',

Data

)

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,075 Most Valuable Professional on at

Like (1)

Report

Hi @AndrejPavlik18 ,

You mentioned Excel - if this is your data source type, what type of column is 'Inter-cluster Sharing' ?

Was this reply helpful? Yes No
AndrejPavlik18 on at

Like (1)

Report

Hi @WarrenBelz
thanks for your answer
No I don´t use like data source excel, the sharepoint is my data source.
And the type of column is choice so you can select multiple options

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (1)

Report
@AndrejPavlik18 ,

OK - that explains the issue - you cannot use GroupBy with a multi-choice column. You can do this

GroupBy( SortByColumns( AddColumns( 'Best Practice Ideas', 'New colum', Concat( 'Sub process', Value, "," ) ), "New colum", SortOrder.Ascending ), 'New colum', Data )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
AndrejPavlik18 on at

Like (1)

Report

I don't know why but it's doesn't work 😞
All code give me the error
Here is my sharepoint list.

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (1)

Report
@AndrejPavlik18 ,

You are missing Value from the code I posted

GroupBy( SortByColumns( AddColumns( 'Best Practice Ideas'; 'New colum'; Concat( 'Intercluster Sharing'; Value; "," ) ); "New colum"; SortOrder.Ascending ), 'New colum'; Data )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No