Unanswered

Need to show the date field column in moth and year view

(0) Share

Report

Posted on by Saan

Hello All,

I am working on customizing one sharepoint list in powerapp. In that i have one date field called Published date.

When i select that item in power app selection showing like below, but i need for selection of month and year display (like in credit card expiry selection - the caleder should show months and year at top).

Is there any way for this? any help is much appriciated..!!!

Saanv

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Saan ,
Just throwing out some ideas, not tested anything.
You could format the control text like Text(ThisItem.'To Date',"mm/yy").. Text(DateValue.SelectedDate,"mm/yy")
If you want a custom control then you could have two dropdowns with the items set to [01,02,03,04...] for months and then [19,20,21...] for the years you could probably even use an expression / collection to give you the current year and next couple.
You could then concatenate the values together when you update SharePoint with in the Update, or a Patch
Concatenate(dpdMonth,"/",dpdYear)

Regards,

Andrew

Was this reply helpful? Yes No
Saan on at

Like (0)

Report
Copy link

Link copied!

Hello Andrew,

I have implemented the both the option like changing the format of date in diplay and also taking both chocie field and then concatenate of those.
But here user is expecting, when ever selecting the caleder icon he wants to see like below

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Saan ,
Not available in the OOTB controls .. but I am sure you could achieve this with a custom component; have you looked at building on of these?
It would need Gallery control to display the months and a header to display and change the Year with the up / down icons..
Totally doable I am sure : -)
Regards,
Andrew

Was this reply helpful? Yes No
Saan on at

Like (0)

Report
Copy link

Link copied!

Would be breat if you could give me any reference link... am new to Powerapps, just trying from all the ways..

Many thanks once gain!!!

Saanv

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@Saan,

Just a quick mockup in PowerApps - it might help

Regards,

Andrew

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@Saan,
No problem, I have not really played around with this too much.. There is some stuff on the PowerApps site about Components.. you can pass-in parameters and output results..
I hope the previous screenshot might help.
Create Component

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Saan,

Does seem easy enough to do, although the parameter / default properties is / was a faff.. MS must do better!!

Example comp in action.. The label below is linked to the output param from the component

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

Like (0)

Report
Copy link

Link copied!

HI @Saan ,

Do you want to see the Months selectors when you click the Calendar icon (DatePicker control) within your app?

If you want to see the Months selectors when you click the Calendar icon (DatePicker control) within your app, I afraid that there is no way to achieve your needs in PowerApps currently.

As an alternative solution, you could consider custom a interactive Calendar view within PowerApps. More details about creating a custom interactive calendar view in PowerApps, please check and see if the following blog would also help in your scenario:

https://blogs.msdn.microsoft.com/davidni/2016/12/13/building-an-interactive-calendar-view-with-powerapps/

In addition, you could also consider create a Calendar Component control based on above blog, then you could use this Calendar Component control repeatedly.

More details about the custom Component in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/create-component

There are some sample components you could reference to:

https://powerapps.microsoft.com/en-us/blog/powerapps-ten-reusable-components/

Best regards,

Was this reply helpful? Yes No