Answered

UpdateContext and Visibility

(0) Share

Report

Posted on by Community Power Pla...

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (1)

Verified answer

nickduxfield 497 on at

Like (1)

Report
Copy link

Link copied!

If you have a dropdown
Switch(Status.Selected.Value,
"Approved", Colour,
"Rejected", Colour,
"Option3",Colour,
DefaultColour)
If you have a Text Column as source
Switch(Status,
"Approved", Colour,
"Rejected", Colour,
"Option3",Colour,
DefaultColour)

Regards

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Here is what I tried to change color of Label text:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

So on this same screen I just have a Label that will show ThisItem.Status. Is there a way to set the color depending on if it is Approved, Pending or Denied?

Was this reply helpful? Yes No
nickduxfield 497 on at

Like (0)

Report
Copy link

Link copied!

If using a contextvariable "StateVariable"
Button.OnSelect
Switch(StateVariable,
1,UpdateContext({StateVariable:2}),
2,1,UpdateContext({StateVariable:2})
)

Gallery Items
Switch(StateVariable,
1,
SortByColumns(Filter(PendingRequest_Table, Status="Approved"),"DateSubmitted",Descending),
2,
SortByColumns(Filter(PendingRequest_Table, Status="Rejected"),"DateSubmitted",Descending)
)

Please enure you understand the field types

Was this reply helpful? Yes No
nickduxfield 497 on at

Like (0)

Report
Copy link

Link copied!

You should not need 2 screens for this unless formatting is too dissimilar.
Pass a context variable on navigate(screen2, transition, {statevariable:2})
Or write to a column in a temp collection that can control States of all screens. Like approved =1, denied =2.
Use a switch case on a gallery to setup filters for each mode.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

So the Status column must have been formated wrong. I changed it to Text and now it is working. Now my next goal is to show only the Approved requests on the ApprovedRequest Screen and the Denied requests on the DeniedRequest Screen. I am thinking I an do this with Filter or is there an easier or better way?

Was this reply helpful? Yes No
nickduxfield 497 on at

Like (0)

Report
Copy link

Link copied!

Investigate the Status field.
What type of field is it?
If it is a complex type, meaning, Status is found in a complextype field that has dependencies.
The error suggests that the Status filed is not what you were expecting, either you changed it to Date and Time by accident, or it is a complect type filed titled status, containing sub fields, or something else.

I.e.
PendingRequest_Table( {Title:"",Status: { StartDate:000000,EndDate:00000 } } )
In this case above you might have to patch the whole thing:
Patch( PendingRequest_Table, Thisitem, {Status: { StartDate:MyDate,EndDate:MyDate}})

If you are able Im happy to sharescreen with you to find out further.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Okay, the Approve and Deny buttons are in the Gallery. But still getting an error:

Was this reply helpful? Yes No
nickduxfield 497 on at

Like (0)

Report
Copy link

Link copied!
If the Approve Requests button is not placed in the Gallery, the formula Patch(Table, thisItem, {}) wont work.
Here are your options.
Put Approve an Reject Buttons directly in the gallery then Patch(PendingRequests_Table, thisItem, {Status:"Approved"})
Change the code to: Patch(PendingRequests_Table,NameofYourGallery.Selected, {Status:"Approved"})
NameofYourGallery.Selected could be the entry PendingRequests, if not, try name all your galleries to Gallery_SomeName so you can bring them up in your code quickly with no confusion.

More info: If you want to do conditional patches that evaluate everyline, try UpdateIf(source, condition, {})

Ps sorry for jumping in there, I havent answered questions for sometime and Im starting to enjoy it again.
Regards

Was this reply helpful? Yes No