IF with a datePicker?

(0) Share

Report

Posted on by freedumz

Hi everyone

I'm trying to do a If with a datePicker

So I have a data source called Source and in this data source I have some date

So I'd like to show some values only if my date are equals

So I use: If(Source.Date=DatePicker.SelectedDate;....; ....) but it's not working, it's returning Argument not valid, I tried other things but it didn't work

(yes my date field is in the date Format)

Many thanks in advance for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

leyburn19 2,157 on at

Like
a
(0)

Report
Copy link

Link copied!

Your IF should be seperated by a , not a ;

If(Source.Date=DatePicker.SelectedDate,...., ....) not If(Source.Date=DatePicker.SelectedDate;....; ....)

Was this reply helpful? Yes No
freedumz 69 on at

Like
a
(0)

Report
Copy link

Link copied!

No no
As my powerapps is in French, I have to use ";" and not ","
I know, it's weird but it's work with ;

Was this reply helpful? Yes No
Sofie_D 260 on at

Like
a
(0)

Report
Copy link

Link copied!

Try using DateDiff function https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-dateadd-datediff
If(DateDiff(Source.Date;DatePicker.SelectedDate)=0;...)

Was this reply helpful? Yes No
Verified answer

freedumz 69 on at

Like
a
(0)

Report
Copy link

Link copied!

I finally found the solution:

If(Date=DatePicker.SelectedDate;...;...)

I don't have to put Source.Date, so I know that I have to give better name to my list columns because If I use another source with a date column it would become tricky

But thanks for your help

Was this reply helpful? Yes No