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

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

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
Super User
Super User

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


@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
Helper V
Helper V

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

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

 

Thanks!!

Highlighted
Helper V
Helper V

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

@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
Helper V
Helper V

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

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
Super User
Super User

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


@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
Helper V
Helper V

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

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!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,506)