Sorting gallery by calculated value error

(0) Share

Report

Posted on by Kubo

Hello,

I'm sorting gallery by value calculated in the gallery this way:

Sort(
AddColumns(
 DataSource,
 "SortField", 
 DateDiff(Last(Filter(DataSource, PersonColumn.Email = Person.Email)).Created, Today()) - number_column
 ),SortField, Descending)

To select items in the gallery I'm using usual "Set(varRecord, ThisItem)"

Everything works fine until I sort gallery this way. After that I'm getting "incompatible types error" everywhere where I used the varRecord. I suspect this is due to schema difference between gallery and record?

Is there any way to filter the gallery with calculated values that would not cause this error?

Thank you very much in advance.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Ram Prakash Duraisamy 5,891 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Kubo,
Hope it won't be an issue, make sure both Form and Gallery contains same DataSource
Kubo 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi rampprakash, unfortunately it is causing issues. I don't have any form based on the varRecord so I cannot tell if its affecting forms.

I'm patching record in several places later, it is in the patching and also in the gallery that I'm getting "incompatible types error". Basically anywhere where I used varRecord I'm getting error after using "AddColumns" function.
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kubo :

Please try:

Sort( DataSource, DateDiff(Last(Filter(DataSource, PersonColumn.Email = Person.Email)).Created, Today()) - number_column, Descending )

Best Regards,

Bof
Verified answer

Kubo 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi all, thank you very much for your replies. I have sorted the issue by not referencing the record directly when patching but using look up.

Set(varRecord, Patch( datasource, lookup(datasource, varRevordID = ID), {column: "123"})))

This have removed the error from the filtered gallery for some reason.