Unanswered

Filter Delegation problems with DatePicker.selecteddate with "Created" column in Sharepoint list

(0) Share

Report

Posted on by Maski84

Good morning everyone!

I have an app that gives me a delegation problem when filtering data because the date format of the DatePicker is different from the "Created" column in SharePoint.

DatePicker1.SelectedDate has this format: 04/04/2023
The "Created" column in a SharePoint list has this format: 04/04/2023 4:31

To compare these values, I changed the format of the "Created" column in Power Apps using the "DateValue" function. Here is my current code:

Filter('Internal Documents', DateValue(Created) = DatePicker1.SelectedDate && StartsWith(Name, ComboBox1.Selected.Value))

How can I avoid this delegation problem? Should I create another column in the list only with the date value? Is there any way to extract only the day without the time in the "Created" column?

Thank you very much for your time!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @Maski84 ,

You just need to add one day - the next day is a 0:00, so it is really the previous day.

Filter( 'Internal Documents', Created >= DatePicker1.SelectedDate && Created < DatePicker1.SelectedDate + 1 && StartsWith( Name, ComboBox1.Selected.Value ) )

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Maski84 10 on at

Like (0)

Report

Hi @WarrenBelz Thanks for you fast response!!

I am trying you solution but maybe make I make any mistake because dosent work propletly i put screens about how my code reacts.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @Maski84 ,

I thought that would work, I was trying to avoid Delegation issues - this works, but you need less than your Delegation limit created after the selected date.

With( { wNext: DateAdd( DatePicker1.SelectedDate, 1, TimeUnit.Days ), wData: Filter( 'Internal Documents', Created >= DatePicker1.SelectedDate && StartsWith( Name, ComboBox1.Selected.Value ) ) }, Filter( wData, Created <= wNext ) )

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No