You’re offline. This is a read only version of the page.
Hello all!
I have a SharePoint list which looks like such
I also have a gallery which updates the information in this list which looks like this
I need to populate a visual that looks like this
I was hoping on this visual that I could place an Icon over each name which would be visible if '1st Audit Complete' = True or '2nd Audit Complete' = True or both for each name on the grid
This would look like this for the data currently in the list
These ticks were manually made visible. Could anyone please think of a way to code this with the list data to become automatically visible?
Any help is greatly appreciated. Many thanks,
Joshua.
Sorry my bad You need to wrap it in !IsBlank() Visible taking only true or false or You will need to add :
Share
Report
All responses (
Answers (
Lookup('Permit Tracker, Title = lbl_EmployeName1.Text && ‘1st Audit Complete’ = true,‘1st Audit Complete’.Value)
Here is similar approach I'm using just in Gallery
!IsBlank(LookUp('NH-Operations-RestrictedDuties-List',Title = ThisItem.Title && Status = "Live",Status))
So if that Record exist my icon is showing up
Morning Seb,
Unfortunately still not having any luck.
Formula is in as advised and with an alternative I have tried.
RE: your question
The 1st Audit and 2nd Audit Complete fields in the List are Yes/No s
Thanks,
Josh.
The Additional true is not required and if formula still showing error use
Lookup('Permit Tracker, Title = lbl_EmployeName1.Text && ‘1st Audit Complete’ = true,‘1st Audit Complete’)
additional question dose ‘1st Audit Complete’ column is Yes/No ? or its a Single text ?
This looks fantastic. Perfectly fit for purpose.
Could you assist me with this please?
Lookup is returning a blank.
Thank you,
Joshua.
if this is way You would like to do this it is possible, just use lookup and place it in Tick Icon Visible property.
First month Tick Icon
Lookup('Permit Tracker, Title = lbl_EmployeName1.Text && ‘1st Audit Complete’ = true)
Secound month tick icon
Lookup('Permit Tracker, Title = lbl_EmployeName2.Text && ‘2nd Audit Complete’ = true)
cause both statement becoming true if the ‘1st Audit Complete’ is mark as true the Tick Icon will become visible
Apologies if my understanding is not perfect. Would it not be possible do it with the data layout currently?
Each name has two audits and the icon will be placed in the relevant date to the image.
Once again apologies if I have a misunderstanding, I very much appreciate the help.
Thanks,
Josh.
So there is no an issue to Automate the Tick Process that's the good news, but there is an issue with Your data.
You need add column what will store Date when one of the Audits was completed to make sure You can distinguish between audits completed on January and July for example right now even if You manage to create the screen as on picture you will not be able to look for right result.
The Screen You designed is also something you can achieve using gallery but this will be difficult for me to explain.
You could create a Static Screen similar to what You have as well and point to it but again You need to at last contain a column what will point to the Month of an Audit 🙂
I suppose my question is ultimately - Is it possible to set the visibility of an icon with the exact row and column value of a SharePoint List?
Hello Seb,
Currently this is just an image capture from an excel sheet which I was going to overlay with tick icons. I am very much up for creating an alternate solution for this if need be. My only concern is I'm not certain if I could have a gallery replicate the grid image well enough.
Thank you.
Is the Audit tracker visual also a Gallery what is connected to same SharePoint List ? or this is something ales ?
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
