Answered

Set current and onwards month

(0) Share

Report

Posted on by Znaanaa

Hi, I am new to powerapps and currently, I need to do enhancements for these apps. I have a dropdown list for the month. I need to make sure the user only can choose the current and onwards month only. The previous month will be visible but the user cannot click it. So far I didn't find any way to do that requirement. Btw the month is from my master list in sharepoint. Here is my screenshot for my apps

Kindly need someone to assist me 🙂

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

VDS_Mantra 175 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

You can use the if condition, make the drop down list with month name & number like Jan(1) and then split the number from this and use the if condition if it is less than current month number then notify.

Hope it will help.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there any particular reason why the previous month should be visible since it will not be used by the user?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Znaanaa 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
There is no reason for that. But it is really good if I can do only show the current and onwards month.

Was this reply helpful? Yes No
Znaanaa 6 on at

Like
a
(0)

Report
Copy link

Link copied!

The month name is from my data source which is master list in sharepoint.

Was this reply helpful? Yes No
VDS_Mantra 175 on at

Like
a
(0)

Report
Copy link

Link copied!

So it there date from which you are fetching month name or just type month name only in sharpoint.

Was this reply helpful? Yes No
Znaanaa 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Just type the month name in sharepoint list( choice type ).

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Znaanaa :

Coud you tell me:

Does Month allow multiple selections?I assume Month do not allow multiple selections.

I have an ideal:

When the customer selects a month before the current month, the combobox will be reset to the default value immediately and an error message will pop up.

I'v made a test for your reference:

Set the combox(I assume it's name is "DataCardValue2")'s OnChange property to:

If( Value(DataCardValue2.Selected.Value) < Month(Today()), Reset(DataCardValue2); Notify("The month cannot be selected, please select the current month or a later month") )

Best Regards,

Bof

Was this reply helpful? Yes No