Unanswered

How to Reference Datacard in sort

(0) Share

Report

Posted on by Community Power Pla...

I'm trying to filter and sort. But not having luck with the syntax for the datacard. What's wrong with it ?

SortByColumns(Filter('1920PersonnelTimesheets',Or(Administrator=User().FullName, Secretary=User().FullName),IsBlank(ApprovalStatus)),"Title",Ascending,StartDateTime_DataCard2,Ascending)

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,
The line
StartDateTime_DataCard2, Ascending
is the issue - you need to sort the field in the data source, not what is in this card - I assume this is StartDateTime
Second issue User().FullName is not a delegable query. Easy to fix - at App OnStart, set a Variable
Set(vUserName,User().FullName)
- so now your code
SortByColumns( Filter( '1920PersonnelTimesheets', (Administrator=vUserName || Secretary=vUserName) && IsBlank(ApprovalStatus) ), "Title", Ascending, "StartDateTime", Ascending )

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you for the advice, but the filter is working fine.

When I try to enter the Column Name "StartDateTime" it does not recognize the column and recommends using the datacard instead. Do you reference a datetime field from Sharepoint differently in the sort ?

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

Like (0)

Report

OK @Anonymous ,
I was making the assumption that this is the field name in your data that is in the card.
What is the field name in your table '1920PersonnelTimesheets' that is in StartDateTime_DataCard2 as this is what you need to Sort on?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

The field is StartDateTime

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

When I write the column name as below, I get the error that this column does not exist

SortByColumns(Filter('1920PersonnelTimesheets',Or(Administrator=User().FullName, Secretary=User().FullName),IsBlank(ApprovalStatus)),"Title",Ascending,"StartDateTime", Ascending)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

I assume it is a date/time field in SharePoint?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Found the problem. The column name had been changed after its original creation.
Once I entered the original column name, it worked.

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

Like (0)

Report

Good @Anonymous ,
It had to be something like that as the syntax I provided should be valid.

Was this reply helpful? Yes No