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

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
CharlesPP 187 on at

Like (0)

Report

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.

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

Like (0)

Report
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

Was this reply helpful? Yes No
CharlesPP 187 on at

Like (0)

Report

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.

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

Like (0)

Report

@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.

Was this reply helpful? Yes No
CharlesPP 187 on at

Like (0)

Report

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

Was this reply helpful? Yes No