cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Saan
Level: Powered On

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

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

calender1.png

8 REPLIES 8
AndrewCarter
Level 8

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

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

Saan
Level: Powered On

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

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

calender2.png

AndrewCarter
Level 8

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

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

Saan
Level: Powered On

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

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

AndrewCarter
Level 8

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

@Saan,

 

Just a quick mockup in PowerApps - it might help

 

CCD Date.PNG

 

Regards,

 

Andrew

AndrewCarter
Level 8

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

@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

AndrewCarter
Level 8

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

@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

 

MonthYearPicker.PNG

Community Support Team
Community Support Team

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

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-power...

 

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 369 members 5,448 guests
Please welcome our newest community members: