Answered

Allowing input form based on the date

(0) Share

Report

Posted on by MIgware1

Hi,

I need to be able to only allow users to enter data on a form, that contains the months and have a dropdown with numbers, based on the current date and not allowing for then to change the data for the past months.

Example: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

2. 4. 5. 2. 1. 0. 1. 4. 3. 4. 5. 6

And assuming the the app reads the information from the system and today is the 1st of September all of the months before September would be locked and would not allow for any inputs to be made. September trough December would be open and would allow for changes to be made.

Any ideias on how this is achievable?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MIgware1 ,

You could set the dropdown's items property to:

Filter(Sequence(12,1,1),Value>=Month(Today()))

Best Regards,

Bof

Was this reply helpful? Yes No
MigWare 4 on at

Like
a
(0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
MIgware1 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

I´ve tried that but that would only allow the dropdowns to insert the numbers of 9 to 12, as we are in September.

The objective if for the dropdows that are past the current month to be greyed out and not allow the user to change the information that is already there

BR,
M

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MigWare ,

The objective if for the dropdows that are past the current month to be greyed out and not allow the user to change the information that is already there.

That is not available. But you could set the dropdown's Onchange property to :

If(Self.Selected.Value < Month(Today(), Reset(Self);Notify("Error Message"))

Best Regards,

Bof

Was this reply helpful? Yes No