Track Status update

(0) Share

Report

Posted on by PowerUser19

215

Hello experts,

I am building a Visitor Automation App. I am stuck with the status tracking part.

There are 3 departments. Requester submit the request and it goes through the approval process. I need to check multiple condition to show the Status of the request. If the visit is required for that department and if the manager has approved, then show the status as Approved, which is simple. But if there are multiple department visits required, even if there is one approval pending, I want to show the status as "Pending Approval". I have attached the images to explain the requirement better.

Scenarios shown in Img3, I need to update the Status in PowerApps (img2) based on the TRUE and FALSE of other columns.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Gochix 1,937 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @PowerUser19 ,

You could count the number of occasions where "TRUE" is less that "Approved" in the specific columns.
Try:
"Status: "& If( CountRows(Filter(YourSPList,RequestID = Dropdown.Selected.Value && 'Dept1 visit Required' = "true")) +CountRows(Filter(YourSPList,RequestID = Dropdown.Selected.Value && 'Dept2 visit Required' = "true")) +CountRows(Filter(YourSPList,RequestID = Dropdown.Selected.Value && 'Dept3 visit Required' = "true")) > CountRows(Filter(YourSPList,RequestID = Dropdown.Selected.Value && 'Dept 1 Mgr Approved' = "Approved")) +CountRows(Filter(YourSPList,RequestID = Dropdown.Selected.Value && 'Dept 2 Mgr Approved' = "Approved")) +CountRows(Filter(YourSPList,RequestID = Dropdown.Selected.Value && 'Dept 3 Mgr Approved' = "Approved")) , "Pending Approval", "Approved")

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
PowerUser19 215 on at

Like (0)

Report
Copy link

Link copied!

Hi @Gochix ,

Thank you so much for your response. The code works but I get delegation warning. Is there any way to fix that?

Was this reply helpful? Yes No
Gochix 1,937 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @PowerUser19 ,

Where exactly is the delegation warning?
Does it comes from :
RequestID = Dropdown.Selected.Value
?

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
PowerUser19 215 on at

Like (0)

Report
Copy link

Link copied!

Hi @Gochix ,
I think it is in both. Please find the attached error msg with code.

Was this reply helpful? Yes No
Gochix 1,937 Moderator on at

Like (1)

Report
Copy link

Link copied!

If you really need to fix the delegation warning then you could collect a new 'In App' collection and use it instead of the connector. This should fix the issue.
However if you planning not to have a large data set then it shouldn't be a problem to use a current formula if it works.

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No