Hi there!
I have a source data list from SharePoint that populates a gallery, from that gallery the user edits the form which patches over to another SharePoint list. So the source list stays in tact and the audit list is updated. Is there a way to highlight/color the row in the gallery when that item has been patched over to the other list. The goal is for the end user to be able to quickly identify which ones they have done and which they have not.
Thanks!!!
Hi! @RachelPalya1 You can use the property "TemplateFill", and then put the color with RGBA(0; 0; 0; 0). For example:
TemplateFill
If(Gallery1.Selected.Status = "OK",
RGBA(new color),
RGBA(current color)
)
Hope it helped you
If this post answers your question, please mark my post as a solution!
If you like my post please click thumb up
Hi @ricardox180, thank you for your response. I updated my template fill with what you provided based on a helper field I added "change". I update the change field to "Changed" and nothing happens.
@RachelPalya1 The other way is for selected item, try with this
If(ThisItem.Status.Value = "OK",
RGBA(new color),
RGBA(current color)
)
Unfortunately, that also didn't work. I was able to find an alternate solution though. For the OnSelect button in my edit form, I updated it to collect the title name. I added a checkmark to my gallery and for that only made it visible if the title was in the collection. That seemed to do the trick, thank you!
@RachelPalya1Ok, Good for you!. I'll shared with you the following formatting conditions that i used for my gallery, Hope it helps you in a future:
Status icons:
Text color
User | Count |
---|---|
231 | |
109 | |
94 | |
57 | |
29 |
User | Count |
---|---|
290 | |
126 | |
106 | |
62 | |
57 |