Power Platform Community Forum Thread Details

Morning.

I have app with 2 Galleries, one which holds employees profiles (email address, start dates, employee IDs etc) and a second gallery which captures info from an MS form each employee has to submit each week.

Currently, if I need to actions something on the employees profile as a result of the form they have submitted, I have to go the 'Home Screen' select the profiles page and search up the employee on the gallery.

Is there a way, with a button I could navigate directly from the selected form of Gallery 2, directly to the form of Gallery 1? Both SharePoint lists contain the employees email address so this would be used to match records.

Many thanks in advance for any support

Categories:

Building Power Apps

Hi @Angry_Sys_Admin

You can use the Navigate function to switch between screens and pass the selected item as a parameter. Here are the steps you need to follow:

On the screen where you have Gallery 2, insert a button and set its OnSelect property to something like this:

Navigate(Screen1, ScreenTransition.Fade, {selectedEmployee: Gallery2.Selected})

This will navigate to Screen1 (where you have Gallery 1) and pass the selected item from Gallery 2 as a parameter named selectedEmployee.

On Screen1, insert an Edit form and set its DataSource property to the same SharePoint list that Gallery 1 is connected to. Then, set its Item property to something like this:

LookUp(YourSharePointList, Email = selectedEmployee.Email)

This will look up the record from the SharePoint list that matches the email address of the selected employee and display it in the edit form.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻