Filter table twice

(0) Share

Report

Posted on by MooseBot88

168

Hi,

I am trying to filter a table I am displaying on my screen twice,

First it needs to be filtered if the status begins with "Transfer From" and then if this record is after "DatePick","HourDropdown" and "MinuteDropdown" which is a date picker, hour dropdown and minute dropdown box on my screen.

In the items property of the table I have

SortByColumns(
 Filter(tblog,StartsWith(status,"Transfer from")
 ),"statusupdated", Ascending)

How do I build the date and time into it aswell. The date and time is recorded in the statusupdated column of my table.

I'm new to powerapps

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

This should do the trick

SortByColumns(
Filter(tblog,StartsWith(status,"Transfer from") && Created > DateTimeValue(DatePick.SelectedDate&" " & HourDropdown.Selected.Value & ":" & MinuteDropdown.Selected.Value)

),"statusupdated", Ascending)

Was this reply helpful? Yes No
MooseBot88 168 on at

Like
a
(0)

Report
Copy link

Link copied!

It doesn't like the "created" part of the formula.

Was this reply helpful? Yes No
MooseBot88 168 on at

Like
a
(0)

Report
Copy link

Link copied!

I wonder if this is because my datasource is excel. The time and date is actually a column called statusupdated?

Was this reply helpful? Yes No
MooseBot88 168 on at

Like
a
(0)

Report
Copy link

Link copied!
This doesn't work either. 🤔
SortByColumns( Filter(tblog,StartsWith(status,"Transfer from") && tblog.statusupdated > DateTimeValue(DatePick.SelectedDate&" " & HourDropdown.Selected.Value & ":" & MinuteDropdown.Selected.Value) ),"statusupdated", Ascending)

Was this reply helpful? Yes No
C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

try this

SortByColumns(
Filter(tblog,StartsWith(status,"Transfer from") && statusupdated > DateTimeValue(DatePick.SelectedDate &" " & HourDropdown.Selected.Value & ":" & MinuteDropdown.Selected.Value)
),"statusupdated", Ascending)

Is your column in excel formatted as a date time column? if its a string this will not work

Was this reply helpful? Yes No
MooseBot88 168 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

This is formatted as dd/mm/yyyy hh:mm but the above doesn't work.

Was this reply helpful? Yes No
Verified answer

C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

have a look at this video, at around 18 minutes it shows you how it should be formatted in excel, if it's not formatted like this you will need to remove the data source from within PowerApps, format it correctly, and re add it into PowerApps.

Power Apps Time zones, UTC, SharePoint, and Excel - YouTube

Was this reply helpful? Yes No
MooseBot88 168 on at

Like
a
(0)

Report
Copy link

Link copied!

Watching the video has been great, I think its best storing my date/time in string format as i'm from the UK and then using the DateTimeValue format.

I changed statusupdated to DateTimeValue(statusupdated) and this seems to work.

Thank you

Was this reply helpful? Yes No