I am working with PowerApps dashboard which has a gallery. My Data source is SharePoint. My gallery calculates the RAG Color for all the fields and displays it (eg, Time, financial, efficiency are the labels and the respective fields have RAG colors(red, green, amber). Time category has two values to be compared(schedule & commitment). If prjmethod.text ="agile" commitment rag must be viewed in gallery or else schedule rag must be viewed in gallery. This prjmethod differs for every project. Is there any way to change the rag color based on the prjmethod condition.
Any help would be greatly appreciated.
Yes, in the color property of the label (any field) add an IF statement, for example:
If(prjmethod.text ="agile", Green, Blue)
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe to my YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
I have written this on the fill property of circle:
StartsWith(projmethodlbl.Text, "^Agile") && EndsWith(prjcontlbl.Text, "T & M"),
ThisItem.Commit = "Red",
ThisItem.Commit = "Amber",
ThisItem.Commit = "Green",
ThisItem.SCHEDULE = "Red",
ThisItem.SCHEDULE = "Amber",
ThisItem.SCHEDULE = "Green",
But its working only for the first condition
If( StartsWith(projmethodlbl.Text, "^Agile") && EndsWith(prjcontlbl.Text, "T & M"), Switch( ThisItem.Commit, "Red", Red, "Amber", Orange, "Green", Green ), Switch( ThisItem.SCHEDULE, "Red", Red, "Amber", Orange, "Green", Green ))
Firstly change the IF statements for a Switch. If Schedule and Commit are different what should the fill colour be?
Keep up to date with current events and community announcements in the Power Apps community.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Check out the latest Community Blog from the community!