Answered

Check a date in a column of sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I'm trying to check if a date that i put in a Date picker matches with dates i have in a sharepoint list but i don't really now how to get to the point (it's my first use of powerapps).

tried to do this but it seems very strange to me (must be a better way).

Thanks for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

ganeshsanap 1,555 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous What exactly the problem is?

The formula you are using is not working or you need better/optimized version of existing working formula?

Please click Accept as solution & ‌‌👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

Best Regards,

Ganesh Sanap

Blog site

Was this reply helpful? Yes No
ganeshsanap 1,555 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous You can also write multiple conditions in one line using OR ( || ) operator like:

If( DebutEmpruntPicker.SelectedDate = reservationtest.DebutEmprunt || DebutEmpruntPicker.SelectedDate = reservationtest.FinEmprunt || FinEmpruntPicker.SelectedDate = reservationtest.DebutEmprunt || FinEmpruntPicker.SelectedDate = reservationtest.FinEmprunt, "Reserved", "Free" )

Documentation: And, Or, and Not functions in Power Apps

Please click Accept as solution & ‌‌👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

Best Regards,

Ganesh Sanap

Blog site

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

For now the ting i realise isn't working, i was more looking for another solution (that works) than optimatisation but thanks anyway

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

For now the thing i realise isn't working, i was more looking for another solution (that works) than optimatisation but thanks anyway

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

Have your solved your problem?

Do you want to compare the DatePicker selected date with the existing date in your SP list?

Could you please share a bit more about the scenario?

From the screenshot you provided, I think you have a start date column and a end date column, also DatePickers for start date and end date. If so, I think you could compare the selected date with

Please try the following formula

If( ThisItem.startD <= DatePicker2.SelectedDate && DatePicker2.SelectedDate <= ThisItem.endD || ThisItem.startD <= DatePicker3.SelectedDate && DatePicker3.SelectedDate <= ThisItem.endD, "reserved", "free" )

Note that you could only compare the current selected date with the date from the current record.

If this could not solve your problem, please post your solution that works on your side, so that our users could get help form here.

Regards,

Qi

Was this reply helpful? Yes No