cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Sort by Name my Gallery (LookUp Column Value)

Hi, maybe is simple but I cannot resolve alone this situation cause i'm a beginner on PowerApps.

 

I try to sort by name my "Gallery1_1" who is taking the information from my sharepoint list "Grille des acquis_1". My gallery use two LookUp column for the name (Nom, Prénom) and the ID (N° Employé).

 

PS: sorry if my english is horrible, i'm french eheh...

 

THANK YOU FOR YOUR HELP!

Capture d’écran (77)_LI.jpg

4 REPLIES 4
Suchitra1996
Resolver II
Resolver II

Hi @Anonymous 

 

As per my understanding, I have done a testing on my end:

The datasource is " Question" and i have sorted it by column "Question" you can do the same with your column "Name".

 

Suchitra1996_0-1614359866248.png

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

Anonymous
Not applicable

Unfortunately this does not work, it is written:

Warning regarding delegation. The "Sort" part of this formula may not work well on large datasets.

Capture d’écran (80)_LI.jpg

Anonymous
Not applicable

I have found a solution that works!

Sort('Grille des acquis_1'; 'Nom, Prénom'.Value)


On the other hand, the same warning message remains present.

Michael_Scott
Regular Visitor

So a delegation warning/error pops up in PowerApps for a few reasons. If you use certain keywords such as "In" while using and if function or if you are trying to access calculated columns or other complex columns. For example a column in a SP list that is set to be calculated like this [LastName] & ", " & [FirstName] with always produce a delegation error. This is because PowerApps does not want to do this work and lookup itself so it 'delegates' it to SP to do and just waits on the values that SP sends back. My guess would be you are using one of these column types. Also if you use Sort function, I believe that you can only name a single column to sort by and you cant call any other functions in that call or it becomes a delegation. Here is a link that may explain it better than me.
Understand delegation in a canvas app - Power Apps | Microsoft Docs

Something I do for smaller lists that I get alot of delegation warnings on is make a quick local copy to read from. For example onVisible for that screen or on app load I will use a ClearCollect function and just copy either the entire list if its small enough or copy only what I want into that local list. This gives you a local copy that you can then pull data from without causing delegation warnings. If you are going to write back to the SP list you will have to remember to make sure you are writing to the correct item in SP and no the item in the local copy. If you have any other questions people on this forum rock and are super polite! Not need to apologize for poor English as most of us probably cant speak another language at all let alone as well as you do! Cheers!

Btw check out Shane Young on YouTube as he is an amazing teacher.
Shane Young - YouTube

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (3,137)