Trying to add in a sort

(0) Share

Report

Posted on by IanP87

Hi,

Getting frustrated with my syntax and hope someone can help

ForAll(Distinct(Filter(PDCodeCostCentreList, Title = Dropdown6.Selected.Result),'Account Code'), {Result: ThisRecord.Value})

I am trying to sort the account code above but when i add in a sort anywhere it wont continue working, can someone help me with the correct syntax please.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 154,393 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @IanP87 ,

Is this what you are trying to do ?

Sort( Distinct( Filter( PDCodeCostCentreList, Title = Dropdown6.Selected.Result ), 'Account Code' ), Value )

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
Verified answer

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @IanP87

Try this

SortByColumns(
ForAll(
Distinct(
Filter(
PDCodeCostCentreList, Title = Dropdown6.Selected.Result ),
'Account Code'
),
{ Result: ThisRecord.Value } ),
"Result",
SortOrder.Ascending
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
WarrenBelz 154,393 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@IanP87 ,
As a matter of interest it is better to get rid of the Microsoft-imposed ForAll(Distinct . . .Result) workaround syntax from all your apps when the output of Distinct (and Split) was changed from Result to Value and simply have the output of these with less code and a .Value output.

Was this reply helpful? Yes No