Icon Visibility Relevant to SharePoint List

[Holland_Joshua]

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.

[SebS]

@Holland_Joshua 

Is the Audit tracker visual also a Gallery what is connected to same SharePoint List ? or this is something ales ?

[Holland_Joshua]

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.

[Holland_Joshua]

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?

[SebS]

@Holland_Joshua 

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 🙂

[Holland_Joshua]

@SebS 

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.

[SebS]

@Holland_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

[Holland_Joshua]

@SebS 

This looks fantastic. Perfectly fit for purpose.

Could you assist me with this please?

Lookup is returning a blank.

Thank you,

Joshua.

[SebS]

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 ?

[Holland_Joshua]

@SebS 

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.