Answered

Calculate fiscal year for a text label in powerapp

(0) Share

Report

Posted on 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:

Building Power Apps

Canvas_app.png

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

SpongYe 5,609 Super User 2025 Season 2 on at

Like (1)

Report
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! 🍻

Was this reply helpful? Yes No
ObiRickC137 44 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

SpongYe 5,609 Super User 2025 Season 2 on at

Like (1)

Report
@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") )

Was this reply helpful? Yes No