Thanks @Marlin-A ,
The varUserMail is your email if you are logged in on this app.
I am assuming if the other users logs in, they update their status in the Tracker List?
You are wanting a status of all members as per the Tracker list in the gallery formed by the Members list and it appears that Member_Email is the linking value between the lists? If so, the icon Colour in the gallery should be
With(
{
vStatus:
Lookup(
Tracker,
Member_Email = ThisItem.Member_Email,
Status.Value
)
},
Switch(
vStatus,
"Log In",RGBA(50 , 205 , 50, 1),
"Log Out",RGBA(213, 0, 0, 1),
"Going On Break",RGBA(255 ,165 , 0, 1),
"Coming Back From Break",RGBA(50 , 205 , 50, 1)
)
)
or have I missed something in the logic above?
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.