Delegation issue - Sort gallery with Dataverse relationship

(0) Share

Report

Posted on by CharlesPP

187

Hello everyone,

I am building a Power Apps (canvas) with Dataverse as data source.

Here is the code I would like to fix (I have the same issue in other places in the app) :

Sort(
 Filter(
 Commandes,
 [Delegable filters]
 ),
 Contact.'Full Name',
 SortOrder.Ascending
)

My problem is that Contact.'Full Name' is not delegable, is there a way to make it delegable ?
I tried using AddColumns, It doesn't show a delegation warning, but it still wasn't delegable.

Thanks in advance for any advice !

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CharlesPP ,

That is one of the main issues with complex field types (and one of the reasons I do not use them unless absolutely necessary) - you cannot sort by them in a Delegable manner. Your best option is to make this a Text field.

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
CharlesPP 187 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz , so my only solution, if I understand correctly, is to have a text field that copies the value of Contact.'Full Name', thanks to a Flow for example.
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CharlesPP ,

You could simply have a Text field (hide it on the Form) and have the Default of the Text box

ThisItem.Contact.'Full Name'

then sort by that

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
CharlesPP 187 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your answer. I don't really understand how to set this up, I don't see how Sort() can filter on anything other than a column in my table, could you give me more details? Thank you.
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@CharlesPP ,

I am saying add a Text field to your data source, put it on the Form and hide it and have the Default as I posted - you would then have a Text field with the value you need to sort as it would save this value each time the Form is submitted.
CharlesPP 187 on at

Like
a
(0)

Report
Copy link

Link copied!

Ahh ok I can see that thanks, that's a good solution. Have a nice day!