Notifications
Announcements
Hi There,
I would like to know how to change the color of a gallery item (cell) if the value within that item is "Complete and closed" - please see attached pic. I only want that gallery item cell to change color, I'm not sure if this is possible. If I cannot change the individual cell in the gallery, how would I change the fill color of a form that gets its value from the gallery e.g. 'Item' is 'Gallery.selected' if the value of a field in the gallery is "Complete and closed"?
@snipesnab
Please have a look at the TemplateFill property for your Gallery.
In that property you can set a formula such as this:
If(ThisItem.Status = "Complete", Green, Transparent)
This would set the row to green if the text Status column is set to Complete.
I hope this is helpful for you.
Spot on - thanks!
Hi @RandyHayes ,
In my case, I am working with powerapps dashboard which has a gallery. My Datasource is sharepoint. My gallery calculates the RAG Colour 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.
Hi Randy
What would the syntax be if you are using a choice field? I am having problems writing this one. 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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 796 Most Valuable Professional
Michael E. Gernaey 327 Super User 2025 Season 2
Power Platform 1919 268