Announcements
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.
Hi @jayceeb
1. Add two dropdowns to save hours (from 0 to 23)
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.
Filter('927Time',Value(Text(ThisRecord.Time,"h"))>=Dropdown1.Selected.Value&&Value(Text(ThisRecord.Time,"h"))<=Dropdown1_1.Selected.Value)
Best Regards,
Levi
hi, Thank you. I tried but it shows this error.
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.
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
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.
the design is like this
Could you please tell me have your problem been solved?
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)
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.
I'm using excel and link to onedrive. not yet solve until now I'm figuring out. 😞
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 883
Valantis 571
11manish 477
