Answered

Calculate fiscal year for a text label in powerapp

Like (0) Share

Report

Posted on 24 Jan 2024 16:48:09 by ObiRickC137

I'm trying to update a Text Label to calculate the current fiscal year, as well as one for the past fiscal year. The form as rich text entries, and one of the text boxes asks for info on the current fiscal year, another asks about progress completing left over goals from the past fiscal year. Our fiscal year is July 1 to June 30.

I'm a SharePoint person by trade, Power Apps is new to me. This is the formula I wrote for a calculated column for current fiscal year: =IF(MONTH(Created)>6,"FY"&TEXT(Created,"yy")&"/"&RIGHT(YEAR(Created)+1,2),"FY"&RIGHT(YEAR(Created)-1,2)&"/"&TEXT(Created,"yy")). The result is FY 23/24

I got as far as posting the current year in Power Apps, but I cannot figure out the way to code years.

Any help is appreciated.

Categories:

Using Apps Using Formulas

Canvas_app.png

All responses (3)

Answers (2)

Verified answer

SpongYe 5,580 Super User 2025 Season 2 on 25 Jan 2024 at 16:28:48

Like (1)

Report
Re: Calculate fiscal year for a text label in powerapp

@ObiRickC137

Here you go:
If( Month(Today()) > 6, "FY" & Text(DateAdd(Today(), -1, TimeUnit.Years), "yy") & "/" & Text(Today(), "yy"), "FY" & Text(DateAdd(Today(), -2, TimeUnit.Years), "yy") & "/" & Text(DateAdd(Today(), -1, TimeUnit.Years), "yy") )
ObiRickC137 44 on 25 Jan 2024 at 16:03:13

Like (0)

Report

Re: Calculate fiscal year for a text label in powerapp

@SpongYe Thank you so much, it worked perfectly!

By any chance could you help me update it to be also for the last fiscal year? I tried modifying what you wrote, I got it to say 22/24, but looking to also have 22/23.
Verified answer

SpongYe 5,580 Super User 2025 Season 2 on 24 Jan 2024 at 17:38:11

Like (1)

Report
Re: Calculate fiscal year for a text label in powerapp

Hi @ObiRickC137

This is a example of the current fiscal year:
If( Month(Today()) > 6, "FY" & Text(Today(), "yy") & "/" & Text(DateAdd(Today(), 1, TimeUnit.Years), "yy"), "FY" & Text(DateAdd(Today(), -1, TimeUnit.Years), "yy") & "/" & Text(Today(), "yy") )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻