How to filter rows based on 12 hour intervals?

(0) Share

Report

Posted on by Usernametwice

503

Hi all

I am trying to filter some rows based on 12 hour intervals, so after 12am I would like to display rows for AM and after 12pm I would like to display rows for PM.

Filter(SortByColumns(Search('Measurement',TextSearchList_2.Text,"name"),"name",Ascending), 'Measurement (Views)'.'Today Active')

Right now I have the relevant rows showing for today and each day they update with 2 new rows ready for AM and PM data but I dont know how to filter them based on AM and PM, or what I would add to the syntax above?

I also have a column that displays AM and PM for each row as seen in the screenshot and a column that displays the current date and time so I think this could help filter AM or PM rows.

Thank you for the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Usernametwice23 :

Could you please tell me what Measurement is ? Is it a SharePoint list?

Could you please tell me what 'AM/PM''s datatype is?

I assume 'AM/PM' is just a text column,please try:

If(
Value(Text(Now(),"HH"))>=12,
Filter(SortByColumns(Search('Measurement',TextSearchList_2.Text,"name"),"name",Ascending), 'Measurement (Views)'.'Today Active' && 'AM/PM'="PM"),
Filter(SortByColumns(Search('Measurement',TextSearchList_2.Text,"name"),"name",Ascending), 'Measurement (Views)'.'Today Active' && 'AM/PM'="AM"),
)

Best Regards,

Bof

Was this reply helpful? Yes No
Usernametwice 503 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft
I really appreciate your help.

Measurement is a dataverse table.

And AM/PM is a Choices column.

Would the syntax be any different in this case?
Thanks again. I'll give it a go tomorrow.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Usernametwice23 :

If AM/PM is a Choices column,the filter condition should be:

Text(First('AM/PM'.Value).Value)="PM"

If AM/PM is a Choice column,the filter condition should be:

Text('AM/PM')="PM"

Best Regards,

Bof

Was this reply helpful? Yes No