Checking selected date matches with any of the date from one SharePoint list

(0) Share

Report

Posted on by Being_Learner

Hello everyone,

In my PowerApp, I have one dropdown field for date selection, and

I have one SharePoint list which have 'date type' (exclude time) column in it.

So after selecting a date I want to check if selected date matches with any of the date from SharePoint list , and if it matches disable one text input.

How can I achieve this ?
Please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

Hello, @Being_Learner, you use the Lookup function:

TextInput.DisplayMode: If(IsBlank(Lookup(SharePointListName, DateColumn=DatePicker.SelectedDate,DateColumn)),DisplayMode.Edit, DisplayMode.Disabled)

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Verified answer

adgkred 228 on at

Like
a
(1)

Report
Copy link

Link copied!
Hey @Being_Learner,

On the DisplayMode property of the text input, try something like that:
If(CountRows(Filter(YourSharePointList, "Date Type" = Dropdown.Selected.Value)) > 0, DisplayMode.Edit, DisplayMode.Disabled)
It should disable the Text input if it can find the dropdown selected value in your Sp List.

Was this reply helpful? Yes No
Being_Learner 31 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @adgkred,

Thank you for your solution it worked with slight modification
If(CountRows(Filter(YourSharePointList, "Date Type" = Dropdown.Selected.Value)) = 0, DisplayMode.Edit, DisplayMode.Disabled)
Instead of checking greater than (>) zero I have changed to equal to (=) zero then it worked as expected.
Thank you once again. 😊

Was this reply helpful? Yes No