Answered

How to get last and not empty date

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello all,

I'm working an app which monitoring project status and i create all the logic for logging and calculations using power apps and power automate, all are works fine. I'm using SharePoint List as data source.

Once the user has entered the start date, they should not be able to enter the date again.

If there is a date, i'm going to disable date picker.

I used this;

DateValue(Last(Filter(Saving, Title = Gallery1.Selected.Title)).Date, "tr-TR")

but when users enter a new data entered without date, it returns blank.

I edit it and try with this but didn't worked.

DateValue(Last(Filter(Saving, (Title = Gallery1.Selected.Title && Not(IsBlank(Gallery1.Selected.Date))))).Date, "tr-TR")

Is there any ideas?

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Maybe you could try:

DateValue(Last(Filter(Saving, Title = Gallery1.Selected.Title && !(IsBlank(Date)))).Date, "tr-TR")

Best Regards,

Bof
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-bofeng-msft ;

It worked! Thank you.
But now delegation warning started. Is there any way to avoid this?
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Maybe you could try:

DateValue(Last(Filter(Saving, Title = Gallery1.Selected.Title && IsBlank(Date)<>Blank())).Date, "tr-TR")

Best Regards,

Bof
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-bofeng-msft ;

Still same. This part highlighted in app;

&& IsBlank(Date)<>
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Sorry, it should be:

DateValue( Last( Filter(Saving, Title = Gallery1.Selected.Title && Date<>Blank()) ).Date, "tr-TR")

Best Regards,

Bof
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

that's brilliant! Thanks a lot.

BR,
Hüseyin