Power Community

Power Community

How to get Quarters from Date in Canvas PowerApps

Implementation Steps:

1. Navigate to https://make.powerapps.com

1.jpg

2. Select Apps –> Select New App –> Select Canvas

3. Once Page Opened Input the name and Select Tablet or Phone depends on your requirement, from my end am selecting Tablet Mode

2.jpg

4. Once Page Get Opened  –> Add a Label by Selecting (Insert –> Label) and Add a Button as Well

3.jpg

5. Now Select the Button and go to OnSelect and Write below code Logic

4.jpg

Code For Converting Date to Quarter

If(
    Month(Now())<=3,
        Set(getQuarterFromDate,”1″),
    Month(Now())>=04 && Month(Now())<=06,
        Set(getQuarterFromDate,”2″),
    Month(Now())>=07 && Month(Now())<=09,
        Set(getQuarterFromDate,”3″),
    Month(Now())>=10,
        Set(getQuarterFromDate,”4″)
)

6. Now Set the Default Value to getQuarterFromDate

5.jpg

7. Now Click on the Button

You will see the Current Quarter Value there.

That’s it 🙂

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Conquer the Clock: Time Management for Sales Teams using Dynamics 365 CRM

In the fast-paced world of sales, time is a precious commodity. Every minute spent on non-essential tasks is lost...

More Articles Like This

- Advertisement -spot_img