Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Drop down gallery

(1) ShareShare
ReportReport
Posted on by

Hi 

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

AndrejPavlik18_0-1721112957501.png

 

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
 
AndrejPavlik18_1-1721112994275.png

 


GroupBy(
    SortByColumns(
        AddColumns(
            'Best Practice Ideas',
            'New colum',
            'Sub process'.Value
        ),
        "New colum",
        SortOrder.Ascending
    ),
    'New colum',
    Data
)
 
Thanks
  • WarrenBelz Profile Picture
    146,524 Most Valuable Professional on at
    Re: Drop down gallery

    @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

     

  • AndrejPavlik18 Profile Picture
    on at
    Re: Drop down gallery

    I don't know why but it's doesn't work 😞

    All code give me the error

    AndrejPavlik18_0-1721128640279.png

    Here is my sharepoint list. 

    AndrejPavlik18_1-1721128688134.png

     

     

  • WarrenBelz Profile Picture
    146,524 Most Valuable Professional on at
    Re: Drop down gallery

    @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

  • AndrejPavlik18 Profile Picture
    on at
    Re: Drop down gallery

    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

     

  • WarrenBelz Profile Picture
    146,524 Most Valuable Professional on at
    Re: Drop down gallery

    Hi @AndrejPavlik18 ,

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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard