I have a couple questions. I have built a Time Off Request app for our employees. I made a PendingRequests Screen where the managers login to approve or deny requests. I used UpdateContext to update the Status column in my Excel depending of if they click Approve or Deny but nothing is populated in my Excel. Here is my OnSelect statement:
Office365.SendEmail(Email,"Time Off Request","Your time off request has been approved.");
UpdateContext({Status:"Approved"})
Second question is on Visibility, I have 3 screens: PendingRequests, ApprovedRequests, and DeniedRequests. So once a request is Approved or Denied, I want the request to only be visible on the appropriate Screen. So on Visible statement I tried:
If (Status = "Approved")
but it did not work, any help would be appreciated. Thank you!