Drop Down Navigation

[fadams_rpc]

drop down navigation from one screen to a trigger a table to populate in another screen. When the user selects an option from the drop down from home screen, it will open to the screen where the table is at that will automatically populate from home screen selection

[Drrickryp · Accepted solution]

Hi @fadams_rpc 

This is a typical scenario for editing a selection in a dropdown.  While you can use the OnChange property of the dropdown to navigate, it is generally not a good idea as it happens instantly and doesn't give users a chance to change their minds about the selection.  To edit the selection in the dropdown and assuming the Items property of the dropdown control (say Dropdown1), is a datasource, (like a SharePoint list, an Excel table or a Dataverse table).  I would put an icon next to the dropdown, perhaps a "pencil" icon with its OnSelect property

Navigate(screen2,None); EditForm(Form1)

On the second screen, I would have a form (Form1), with the DataSource property of your table and the Item property Lookup(datasource, ID=Dropdown1.Selected.ID). 

If you are looking to populate a datatable control based on a dropdown, you would filter the datatable Items based on the selection in the dropdown. This can be done on one screen as shown  in the screenshot.   If you wanted them on different screens, put a ">" icon next to the dropdown with an OnSelect property simply Navigate(screen2,None).  The Items property of the datatable control is shown in red above it in the screenshot.