Answered

How to Reference Datacard in sort

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

WarrenBelz 156,319 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 156,319 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The field is StartDateTime

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

Like
a
(0)

Report
Copy link

Link copied!

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 156,319 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

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

Like
a
(0)

Report
Copy link

Link copied!

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 156,319 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No