How to remove DELEGATION warning

[ashokpershad]

I am using below formula for one of my canvas app screen dropdown where I want all numbers(text type) to be filter out in Ascending order. 

Distinct(Sort(Overalls, Value('Overall WO'), Ascending),Value('Overall WO'))

I am getting Delegation warning  in 1st Value function (Value('Overall WO'). How shall I remove this Delegation warning. Please support.

Also, what formula shall I use in case I don't want to convert the Text type to Value and it just filter out the Numbers (text type) in ascending order?

[dpoggemann · Accepted solution]

Hi @ashokpershad ,

Couple options:

1.  Can you do the query and pull back all of the values and populate a Collection?  You should then be able to sort / do distinct on the collection and remove the delegation.

2.  If you are utilizing AutoNumber in Dataverse and want to sort the records as Numbers...

My thought here is you could create a Power Automate Flow that would trigger on creation of the record or update of your AutoNumber field and have it convert the AutoNumber to a Whole Number and populate another field on your table.  This could be utilized as the default "sort" order for your table or on a specific view that is sorted and when you pull up in Canvas App you can utilize this view.  I am still concerned that if you are trying to do a "Distinct" you will still get the unique set.  If this is an autonumber field you should not have duplicates though so Distinct would not be required in this situation.