Answered

Datepicker Filtering for gallery issue

(0) Share

Report

Posted on by CU08060810-0

I'm trying to create a datepicker for a Gallery. Since my data source is an excel, it reads the dates as text even though it has been formatted as a date in the excel.

Currently, my date picker Onselect is: Filter(Permit_V2,'Permit Status'="Approved", IsBlank(DatePicker1.SelectedDate) , DateValue(Dateofworktobedone, "en-GB")=DatePicker1.SelectedDate)

 
Gallery: 
Filter(Permit_V2, 'Permit Status' = "Approved", IsBlank(VarFilter) || 'Location of work' = VarFilter || IsBlank(DatePicker1.SelectedDate) || DateValue(Dateofworktobedone, "en-GB") = DatePicker1.SelectedDate)
 
Text for the Dateofworktobedone field: 
DateValue(Text(ThisItem.Dateofworktobedone, "dd/mm/yyyy"), "en-GB")
 
The problems are that the dates are still formatted in US format, and the other main issue is that it does not filter at all? Are there any troubleshooting solutions for this issue? 

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@CU08060810-0,

Gallery (Items)

Filter(

    Permit_V2,

    'Permit Status' = "Approved",

    IsBlank(VarFilter) || 'Location of work' = VarFilter,

    IsBlank(DatePicker1.SelectedDate) || DateValue(Dateofworktobedone, "en-US") = DatePicker1.SelectedDate

)

Label showing the work date

Text(

    DateValue(ThisItem.Dateofworktobedone, "en-US"),

    "[$-en-GB]dd/mm/yyyy"

)

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @CU08060810-0,

I will add something here making a few assumptions. Firstly, assuming you are using SharePoint and Dateofworktobedone is an actual Date field, you do not need any conversion - dates are actually stored in UTC format and converted by the Regional Settings of either the browser (Power Apps) or the SharePoint site (if viewed in SP). I am not sure why you have a FIlter OnSelect of the Date Picker (it needs to be an action of some sort, not a data set), but the Items of the Gallery would simply be
Filter( Permit_V2, 'Permit Status' = "Approved", IsBlank(VarFilter) || 'Location of work' = VarFilter, IsBlank(DatePicker1.SelectedDate) || Dateofworktobedone = DatePicker1.SelectedDate )

Assuming alternatively that Dateofworktobedone is stored as Text in your Data Source (the type does not matter), then you have a Delegation issue (@MS.Ragavendar's code will work fine excluding this matter) but do not need to convert the field value to compare it (DateValue will actually work better on it in US format)- but you can set the Date Picker Format as

"dd/mm/yyyy"

and it will display as you need it to. The Gallery Filter would be (to manage the Delegation issue)
With( { _Data: Filter( Permit_V2, 'Permit Status' = "Approved", IsBlank(VarFilter) || 'Location of work' = VarFilter ) }, Filter( _Data, IsBlank(DatePicker1.SelectedDate) || DateValue(Dateofworktobedone) = DatePicker1.SelectedDate ) )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No