Dates within Gallery and Form

(0) Share

Report

Posted on by CC-19121430-0

240

Hello,

1. I was wondering if it is possible to only have Month and Year visible within my Gallery and how to do this?

2. I also have a form that I would, if possible, want to add a restriction so that the 1st of the month must be selected and doesn't allow the form to be saved until this criteria is met, alternatively if it's possible to change within gallery any date selected within the form/date picker to the 1st of the month if another has been entered.

Any help is very appreciated! I am new to Power Apps and getting there slowly!

Many thanks

Chris

Categories:

General Questions

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 151,631 Most Valuable Professional on at

Like (0)

Report
Re: Dates within Gallery and Form

Hi @Appy1 ,

OnChange of the Date Picker, put this

UpdateContext({varDate: DateValue(Month(Self.SelectedDate) & "/1/" & Year(Self.SelectedDate))}); Reset(Self)

and the DefaultDate

varDate

No matter which day they pick, it will select the first of that month.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report

Re: Dates within Gallery and Form

Hi @WarrenBelz
Thanks for this, it is very close to working.
I am in the UK so the date format isn't quite right, how would i change this to my regions date format?
Many thanks
Chris

Was this reply helpful? Yes No
MithaliGupta 242 on at

Like (0)

Report

Re: Dates within Gallery and Form

You may try setting variable like this
UpdateContext({varDate: DateValue(Month(Self.SelectedDate) & "/1/" & Year(Self.SelectedDate))});
Reset(Self)
And this will return default value as month and year

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report

Re: Dates within Gallery and Form

Hi @MithaliGupta
Thanks but that appears to be also providing the same US format.
Kind Regards
Chris

Was this reply helpful? Yes No
Verified answer

WarrenBelz 151,631 Most Valuable Professional on at

Like (1)

Report
Re: Dates within Gallery and Form

@MithaliGupta .

You have again repeated my post - I will always respond as my time zone permits (so please allow me to do this)

@Appy1 ,

You just need

UpdateContext( { varDate: DateValue( "1/" & Month(Self.SelectedDate) & "/" & Year(Self.SelectedDate) ) } ); Reset(Self)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No