web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Adding "SortbyColumns"...

Power Apps

Answered

Adding "SortbyColumns" to the statemecauses "Incompatible type.

(0) Share

Report

Report

Posted on by DenisSkorskiy

22

Hello,

Would you please help with the following.
There is a statement that works perfectly:

Set(SelectedObjectName, First(Filter('[dbo].[Objects]', ParentObjectId = WorkingParentObjectId)).Name)

Now I need to sort data output before taking the first record. I use SortByColumns function, like this:

Set(SelectedObjectName, First(SortByColumns(Filter('[dbo].[Objects]', ParentObjectId = WorkingParentObjectId), "SortOrder")).Name)

And immediately get "Incompatible type..." error, like below:

Incompatible type error.PNG

I assume that this is because delegation cannot be used and statement cannot be resolved.

Does anybody know work-around?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@DenisSkorskiy
Actually, it’s because SortColumns is missing an argument

Set(SelectedObjectName, First(SortByColumns(Filter('[dbo].[Objects]', ParentObjectId = WorkingParentObjectId), “YourSortColumn1”, Ascending)).Name)

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

DenisSkorskiy 22 on at

Like
a
(0)

Report
Copy link

Link copied!

It is very strange.
In the reference it is said that SortOrder is optional.
Just for the sake of curiosity, I set this third parameter - and error disappeared.
Needless to say that I use this function with just two parameters in other places of the application and it works perfectly.

mdevaney, thank you!

Was this reply helpful? Yes No

Join the conversation