cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jayceeb
Helper III
Helper III

Time range Filter based on one column

Hi, I had one column named Time Filter.

I want to get the time range from 6am to 6pm or any time that I want to filter

how can I filter it using dropdown ? give suggestion please.

11 REPLIES 11
v-liwei-msft
Community Support
Community Support

Hi @jayceeb 

 

1. Add two dropdowns to save hours (from 0 to 23) 

vliweimsft_0-1664271993460.pngvliweimsft_1-1664272005738.png

 

 

2. Use the Text function to convert the date column of the data source to hours. 

3. Use the Value function to convert the string returned by the Text function to a number. 

4. Use the Filter function to filter.

vliweimsft_2-1664272020602.pngvliweimsft_3-1664272047948.jpeg

Filter('927Time',Value(Text(ThisRecord.Time,"h"))>=Dropdown1.Selected.Value&&Value(Text(ThisRecord.Time,"h"))<=Dropdown1_1.Selected.Value)

 

Best Regards,

Levi

jayceeb
Helper III
Helper III

 

 

hi, Thank you. I tried but it shows this error.

jayceeb_2-1664273687805.png

 

v-liwei-msft
Community Support
Community Support

Hi @jayceeb 

 

Could you please provide a screenshot of how you are setting the dropdown's items property? 

Make sure that the array you enter in the items property of the dropdown contains numeric data rather than strings.

 

Best Regards,

Levi

jayceeb
Helper III
Helper III

hi thank you . I got no error however it shows blank I think my column is already in Text when I patch as text. how the data will appear

 

jayceeb_0-1664337601862.png

 

v-liwei-msft
Community Support
Community Support

Hi @jayceeb 

 

Can you show me how you designed your dropdown? 

According to the test I showed you, if you want to display between 6am and 6pm, you should choose six in the first dropdown and 18 in the second dropdown.

 

Best Regards,

Levi

jayceeb
Helper III
Helper III

the design is like this

 

jayceeb_0-1664339850874.png

 

v-liwei-msft
Community Support
Community Support

Hi @jayceeb 

 

Could you please tell me have your problem been solved?

 

Best Regards,

Levi

jayceeb
Helper III
Helper III

my data source name is Breakages , the name of my column Date and Time.. format is like this Sunday, September 11, 2022 6:55:10 AM

I use below codes however It shows blank. 😞

 

Filter(Breakages,Value(Text(ThisRecord.'Date and Time',"h"))>=Dropdown1.Selected.Value&&Value(Text(ThisRecord.'Date and Time',"h"))<=Dropdown1_1.Selected.Value)

v-liwei-msft
Community Support
Community Support

Hi @jayceeb 

 

This may be caused by the time difference issue, the time in powerapps shows the local time. 

If your data source is SharePoint, the time column is in UTC time.

 

Best Regards,

Levi

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,197)