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.
Hi! @RachelPalya1 You can use the property "TemplateFill", and then put the color with RGBA(0; 0; 0; 0). For example:
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:
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT