Answered

Sort By Columns- Specific Date Value

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I was trying to follow the tutorial listed at: https://powerapps.microsoft.com/en-us/tutorials/function-sort/

However, I was having issues with sorting a specific column by a specific value. Similar to the tutorial, I wanted to sort my listings to only those that would have an "EventDate" equal to Today().

Here is my original code:

SortByColumns(Search(Table2, TextSearchBox1.Text, "EventName", "LastName", "FirstName"), "EventDate", If(SortDescending1, Descending, Ascending))

I would like it to be something like: "EventDate", [Today()] -- Not sure if it's supposed to be ["Today"] I tried both and couldn't get it working.

Thanks for all of your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Should I try to use Filter instead of SortByColumns?

Thank you!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Sorry, I answered my own question. I used filter and it works properly.

The app is for an event check in. So depending on the last name they enter into the search textbox, and if the event is today, it allows them to check in.

If any one needs help, here's the code I used:

Filter(Table2, LastName = TextSearchBox1.Text, EventDate = Today())

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Austinct,

I am glad to hear that you have figured out a solution.

And thanks for sharing it with us.

Anytime you have issues when using PowerApps, please feel free post your issue at here, we are always ready to help.

Best regards,
Mabel Mao

Was this reply helpful? Yes No