web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Date picker suddenly n...

Power Apps

Answered

Date picker suddenly not filtering

(0) Share

Report

Report

Posted on by VegakunLee

5

Hi all!

I currently faces the issue of the date picker suddenly not working on Power App.

I have checked the data source, which is still working as per normal.

The filtering formula I was using is

Filter(SharepointList,DateDiff('ColumnName',DatePicker.SelectedDate,TimeUnit.Days)=0)

The weird thing is all new entries into the sharepoint list after 14th July cannot be recognized and filter.

Everything before can be filtered and shown as per normal.

But all along there has been no changes to the sharepoint list, our power automate flows, and the power app itself.

I tried recreating but it is not working as well.

Here shows part of the list, filtering is based on 'Request delivery date'. Despite the delivery date being the same, one was submitted before 14th July, one submitted after.

I should have two being shown in my app, but only one shows up.

Anyone encountered this before and may have a solution to it?

Thank you very much in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @VegakunLee ,

The formula is not delegable. Please try:

Filter(SharepointList,'ColumnName'=DatePicker.SelectedDate)

Or

With( {SelectedDate:DateAdd(DatePicker1.SelectedDate,TimeZoneOffset(),TimeUnit.Minutes)}, Filter(SharepointList,'ColumnName'=SelectedDate) ）

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation