cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Icon Color

Hello,

 

I am building a managers view for attendance, 

I have already an app which will record if the members is logged in or logged out

error.png

and this is the Columns for this 

1.PNG

 

And I am building this Manager's View App
Eyes.png

I already filtered this gallery based on the members who is reporting to me.

The source on this gallery is this.

Logs.PNG


What I want now is to change the Icon Color based on the status on the Tracker. 

In the Screenshot provided the Icon Color is Green because It already captured the old entry on the list.

* Looking on the first screenshot I already logged out which means the icon should be now red, but still captured the old one.

Mentioning sir @WarrenBelz on this. 
Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions

Hello @Marlin-A 
Add a column Status to your Members list. On the Log On button

If(
   IsBlank(
      Lookup(
         Members,
         Member_Email = ThisItem.Member_Email,
         Member_Email           //there is no item present
      )
   ),
   Patch(
      Members,
      Defaults(Members),
      {
         User_Email:User().Email,
         Status:"Logged On"
      }
   ),
   UpdateIf(
      Members,
      Member_Email = ThisItem.Member_Email,
      {"Status: "Logged On"}
   )
)

On the Log Off button - the member will already be there

UpdateIf(
   Members,
   Member_Email = ThisItem.Member_Email,
   {"Status: "Logged Off"}
)

 

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.

 

View solution in original post

4 REPLIES 4
Super User III
Super User III

Hi @Marlin-A ,

From the previous post, you wanted to show the latest item for the user, this seems to be a different question again.

I thought we had solved the icon colour question - can you please elaborate on exactly what extra items you want to solve.

Ok @Marlin-A ,

You want one item only from the user (the latest) and you want the icon to change colour depending on what the status is and you have a list called Tracker which contains all logging information but you need one record from EACH user.

I had a go at this, but it is way too complex - you would have to cycle through the entire Tracker list in descending order and then on each item check if it was already in the list.

Can I please make another suggestion that would work perfectly. Have a list of users and a Status and simply Patch to this when a button was pushed. You could automatically add new users to the list if the user was not already there by doing a lookup and having a new item rather than an update.

 

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.

 

 

Hello @WarrenBelz ,

 

Thank you, What I am struggling to do right now is to make a column on my members list and then If I push the button it will also update real time on the Members list. So it is easy to called the status value.

Patch(
    WFH_Tracker,
    Defaults(WFH_Tracker),
    {
        Member_Name:DataCardValue2.Text,
        Member_Email:DataCardValue1.Text,
        Status:DataCardValue3.Selected,
        Submission_Date:Now()
    }
);

I have this patch syntax on my submit button, figuring out how can I update the specific column record on Members SP list based on the Member_Email

 

Thank you!

Hello @Marlin-A 
Add a column Status to your Members list. On the Log On button

If(
   IsBlank(
      Lookup(
         Members,
         Member_Email = ThisItem.Member_Email,
         Member_Email           //there is no item present
      )
   ),
   Patch(
      Members,
      Defaults(Members),
      {
         User_Email:User().Email,
         Status:"Logged On"
      }
   ),
   UpdateIf(
      Members,
      Member_Email = ThisItem.Member_Email,
      {"Status: "Logged On"}
   )
)

On the Log Off button - the member will already be there

UpdateIf(
   Members,
   Member_Email = ThisItem.Member_Email,
   {"Status: "Logged Off"}
)

 

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.

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (10,135)