Introduction
In this Blog we will see how to get Quarters from Date in Canvas PowerApps
Implementation Steps:
1. Navigate to https://make.powerapps.com
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
4. Once Page Get Opened --> Add a Label by Selecting (Insert --> Label) and Add a Button as Well
5. Now Select the Button and go to OnSelect and Write below code Logic
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
7. Now Click on the Button
You will see the Current Quarter Value there.
That's it
No comments:
Post a Comment