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

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

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!

16 REPLIES 16

wow! that works like magic! I just used the UserEmail instead of User().Email since I have already defined it in my app. It works flawlessly. 

 

I am also thinking to have another button somewhere as "SHOW ALL" which should take me back (out of Managers record button) to the original gallery with current users submitted form. Do I use filter function on that?

View solution in original post


@asdeev wrote:

wow! that works like magic! I just used the UserEmail instead of User().Email since I have already defined it in my app. It works flawlessly. 

 

I am also thinking to have another button somewhere as "SHOW ALL" which should take me back (out of Managers record button) to the original gallery with current users submitted form. Do I use filter function on that?


Awesome! glad it worked.

 

And yes , for "Show All" button, set the OnSelect Property to Set(FilteredWorkOrders,'[dbo].[JHA_APP]') so that you can see all the work orders. you could also use sort within that statement if required.

 

Also, can you accept the previous reply as the solution.

 

Thanks

Vivek Bavishi / That API Guy

Twitter | YouTube | Blog


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Awesome!! Thanks a ton and yes I did some sorting in the above function you mentioned and it works just fine.

 

Thanks!!

@ThatAPIGuyI have another question. Sorry to bother you but in this scenario,

 

When i click managers record button I am getting all the forms manager has approved/rejected but I have this delete button on each form for the users to delete them if they wish to do so( FYI- everything is logged in my deletedhistory table in backend. )

 

However, when the user deletes the button it is also geeting removed from the managers record page;

 

I dont want the managers records to be deleted you know what I mean. I hope this is making sense. 

Is there a way I can hide all those 3 ( edit,copy and delete icons (please refer pictures) for the managers? ) if not is there a way I can make the forms still be present for the managers record even when user decides to delete them ?

 

 

I have attached the pictures for reference . 

I also have a history table or deleted records table. 

 

 

I am thinking what if I use history or deletedrecords tables in the managers button (onselect property) . That way maybe they can see all the records they have approved or rejected even when user deletes them from their app?

 

Not sure if I am thinking right or if this is even possible. Just a thought. 


@asdeev wrote:

I also have a history table or deleted records table. 

 

 

I am thinking what if I use history or deletedrecords tables in the managers button (onselect property) . That way maybe they can see all the records they have approved or rejected even when user deletes them from their app?

 

Not sure if I am thinking right or if this is even possible. Just a thought. 


yes, you will have to join the records from the two tables (managers approved /rejected records and user deleted records which the manager has approved or rejected) into one collection.

 

 

 

 


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Oh joining two tables using a unique id? just like sql?

Maybe using ClearCollect()?

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (18,073)