Unanswered

How to check a list of dates in a collection against a sharepoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to Check selected dates in the PowerApps against a list of dates in a SharePoint list. Below is what I am trying to do.

I have 2 date pickers (start date and end date).

For example, I selected start date as 01/09/2021 and end date as 03/09/2021.

In share point list i have 2 column which i need to check (i.e. From and To).

I want to loop through these 3 dates and check if any of these dates exists in my Scheduler list. Right now, I am creating a collection on OnChange property of end date picker but i am not getting desire my output.

ClearCollect(
colCheckDates,
Filter(
Scheduler ,
RequesterEmail = User().Email &&
To >= DataCardValue15.SelectedDate
)
);

I have gone through this thread but i am confused for some reasons.

Any help would be appreciated.

Thanks

Ahmad

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I did not encounter this.

Please check the following:

Is your Sharepoint set the correct time zone?

Whether there are items that match user.email in the RequesterEmail column?

Does the Date column contain time?

Best Regards,

Wearsky

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

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the response.

Here is what want below:

RequesterEmail From To
test1@outlook.com 09/02/2021 09/03/2021
test1@outlook.com 09/06/2021 09/06/2021
test1@outlook.com 09/07/2021 09/09/2021
test2@outlook.com 09/07/2021 09/07/2021

If test1@outlook.com select any start and end date from date picker in power apps and if it lies "between" or "equals" to From and To in share point list then condition should be true other wise false.

Does the Date column contain time? Ans: No
Is your Sharepoint set the correct time zone? Ans: both Power apps and Sharepoint configured in local time zone.
Whether there are items that match user.email in the RequesterEmail column? Ans: I am required to compare with email because there will be multiple different email record exist in SP list.

I would be happy if I get any possible solution.

Regards
Ahmad

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You could try lower() function.

ClearCollect( colCheckDates, Filter( Scheduler , Lower(RequesterEmail) = Lower(User().Email), To >= DataCardValue15.SelectedDate, From<= Your datepicker control 's name.SelectedDate ) );

Best Regards,

Wearsky

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to check a list of dates in a collection against a sharepoint list

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the June Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates

RequesterEmail	From	To
test1@outlook.com	09/02/2021	09/03/2021
test1@outlook.com	09/06/2021	09/06/2021
test1@outlook.com	09/07/2021	09/09/2021
test2@outlook.com	09/07/2021	09/07/2021

Community site session details

How to check a list of dates in a collection against a sharepoint list

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the June Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Apps

Featured topics

Product updates