Color Code Gallery based on sharepoint values

(0) Share

Report

Posted on by venka91

1,119

Hi there,

I have a dental app. The screen has a gallery with 32 tooth pictures. Doctors will be selecting the tooth numbers based on the diagnosis made. Example, Extraction, Root canal, Missing or Restoration. Each of this option have color codes.

When Extraction option is selected, and tooth image is clicked, this image background will turn into Yellow. The tooth number which is clicked will be stored into sharepoint when i click the Patch button.

Now, i need a help on displaying the data back from sharepoint. Example, On a Search Patient Screen, when i enter the Patient id, this will pull the details of the patient from Sharepoint list.

Now i also want to display the gallery with the data that is stored in the database with the same color highlighting as per the diagnosis. The tooth number diagnosed i am successfully able to show in the text box. But in gallery, how should i highlight the tooth number ?

Is it possible to do with gallery. I am attaching the screen how it should like when i pull the patient id from sharepoint list.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

Hi @venka91 <"
The best way would be the fill or text color of the label in the gallery. You would have to apply the same rules as you have to the tooth image.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
rizkyaditya 292 on at

Like (0)

Report
Hello @venka91 ,

Highlighting gallery based on its value is possible.
I assume each tooth displayed inside the gallery represents each row of data in your sharepoint list.

You can try this in the TemplateFill property of your gallery :
If(ThisItem.diagnosisColumn = "Extraction", Yellow, If(ThisItem.diagnosisColumn = "Root canal", Blue, If(ThisItem.diagnosisColumn = "Missing", Black, Red)))

You can adjust the syntax to better suit your actual condition with the color.
I hope this helps!

Was this reply helpful? Yes No