web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Conditional Formatting...
Power Apps
Answered

Conditional Formatting with Fiscal quarters

(0) ShareShare
ReportReport
Posted on by 67

Hello,

 

I am creating an app that use's fiscal quarters(Q1, Q2, Q3, Q4) to track progress of work being completed. 

 

There is a start date which runs of fiscal quarters. I have bee asked to do conditional formatting in a gallery that if work that was due in Q1 has not been completed and it is now Q2 then an icon's colour turns to red.

 

I am unsure of where to even start and my haven't got close to getting it working.

 

I will answer any questions, thank you

Categories:
I have the same question (0)
  • Verified answer
    Shea1 Profile Picture
    67 on at

    Got it working by setting variables for the end date of each variable in my onStart.

    Then I use a switch statement to check ThisItem.Quarter. Then use an if to determine the colour of the icon.

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard