Answered

Choice Field Choices depending on Date Picker

(0) Share

Report

Posted on by Taylor28

Hi,

I have a SharePoint list that has a Date column and a Choice field column. The choice column allows for multiple selections. What I would like to do is filter the available options based on the date selected. For example, the choice column has 10 options to choose but if I select 09/06/2023 the options are limited to 3 options. The dilemma I'm running into with the Filter function is it being two different column types(Date,Text).

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Taylor28 ,

Can you provide your formula you filled in, so that I can solve your issue properly.
According to the error Message and Conditions. Please try this:
If(DatePicker1.SelectedDate = Date(2023,9,6),[1,2,3])

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
Taylor28 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Tina,
Thank you for your response, it seems to be working as expected. If I wanted to add another date to the formula, do you know what the formula would be?

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @Taylor28 ,

Please try this:
If(DatePicker1.SelectedDate = Date(2023,9,6) || DatePicker1.SelectedDate = Date(2023,9,7),[1,2,3])

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
Taylor28 52 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks Tina! This worked as expected.

Was this reply helpful? Yes No