Having managers see the approved or rejected forms in powerapps Form App

[asdeev]

Hi Guys,

I was wondering if there a way in the App for the managers to see what forms they have approved or rejected??

I have a form for users to submit work orders and managers get emails they approve or reject it but Is there a way I can somehow create a button or something for the managers to see what forms they have had approved or rejected ?

I hope this is making sense. Any ideas are highly appreciated!!

Thanks alot!

[ThatAPIGuy · Accepted solution]

This is just one way of doing it -

First, create a column "Approved by" in your data source where you are saving the work orders.

When the manager approves a work order, which I am guessing you are using a Flow for, you can add an action to update the "Approved by" value to the manager's email address. 

In the app, you can create a manager section, which only managers can view and here you can show which work orders they approved by using the Filter function - 

Filter(WorkOrders, 'Approved by' = User.Email()) 

Edit - it should be Filter(WorkOrders, 'Approved by' = User().Email) 

Hope this helps. Let me know if you have any questions.

Thanks

Vivek Bavishi / That API Guy

Twitter | YouTube | Blog

[asdeev]

Thanks for your response.I already have ManagerAlias coloumn in my table which stores the information of all approvers.(basically managers)

and yes I use the flow for approvals.

I inserted a button in the gallery of my app called Manager's record ( I am not sure if this is right) but I only want this to be seen by managers How can I do that?

Like you said I created a filter on the button onselect property:  Filter('[dbo].[JHA_APP]',ManagerAlias= User.Email()) - the error I am getting is inovation of unknown and unsupported text.

Please see the attached.

It shows 

[ThatAPIGuy]

My bad , it should be User().Email

[asdeev]

It gives me delegation warning (Please see ataached) .

[ThatAPIGuy]

And for your dilemma on whether to use manager's record button, I believe you could set the visible property to true only if the logged in user is in the list of managers . Let me know if you would like to understand the formula for that.(probably a lookup function)

[ThatAPIGuy]

---

@asdeev wrote:

It gives me delegation warning (Please see ataached) .

---

As per this documentation https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list , it should be delegable and you shouldn't get a warning. 

Is it working though with the warning?

[asdeev]

That would be very helpful. I havent used lookups before so if I can get an example on how to use the formula , that would be great and I really appreciate your time.

Thanks!

[asdeev]

I dont see the results. Do you think I should have a filter on gallery too? Right now my gallery filters based on the current logged in users only and I have added another button for managers record with the above formula.

Will that affect the button functionality?

I have attached the picture of gallery screen

[ThatAPIGuy]

---

@asdeev wrote:

That would be very helpful. I havent used lookups before so if I can get an example on how to use the formula , that would be great and I really appreciate your time.

Thanks!

---

Firstly, lets take a step back and understand how are you filtering the gallery when the manager clicks on the button.

Right now, the filter formula won't work as you are not filtering the gallery items based on the formula. 

1. Set the Gallery Items to some variable - FilteredWorkOrders

2. Then onvisible property of the screen, use the formula Set(FilteredWorkOrders, your gallery items formula that you have currently)

3. Then for the OnSelect property of the Manager button, use this - Set(FilteredWorkOrders, the filter formula that you are using for the button)

4. for the visible property of the Managers button , use this - If(IsBlank(Filter('[dbo].[JHA_APP]','ManagerAlias'=User().Email)),false,true)

Which means if the user who logged in has atleast one record that they approved, the button will be visible otherwise it won't.

Hope this helps.