cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted

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

Highlighted


@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

Highlighted

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

 

Thanks!!

Highlighted

@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 . 

Highlighted

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. 

Highlighted


@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.

Highlighted

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

Maybe using ClearCollect()?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,794)