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

Enable Early Access Wave 1 2023 | Power Platform

Like every 6 months, enabling Early Access is one of the best things to look forward to as Microsoft...

More Articles Like This

- Advertisement -spot_img