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

Same table lookup - list box working dropdown not working

Hello everyone,

I have a list box calling a table menu at the onStart Property of the app, however I would like this to be a Dropdown instead - I have applied the same code but nothing happens - I have completed logged out of the app - did a run on start - CDS - see attached

Thanks for your help

Sigi

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @shawkinson ,

 

This is because that you have used the Table function and that makes the screens become records in the table, so it won't be referenced to the screens inside the app. 

 

Please use below formula instead:

If(ListBox1.Selected.Value="My Open Opportunities",Navigate(ScreenListMyOpenOpps,None),
ListBox1.Selected.Value="All Open Opportunities",Navigate(ScreenListAllOpenOpps,None),
ListBox1.Selected.Value="My Won Opportunities",Navigate(ScreenListMyWonOpps,None),
ListBox1.Selected.Value="All Won Opportunities",Navigate(ScreenListAllWonOpps,None),
ListBox1.Selected.Value="My Lost Opportunities",Navigate(ScreenListMyLostOpps,None),
ListBox1.Selected.Value="All Lost Opportunities",Navigate(ScreenListAllLostOpps,None))

 

Regards,

Mona

Community Support Team _ Mona Li
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

7 REPLIES 7
Microsoft
Microsoft

Hi @shawkinson ,

You would need to put your formula on "OnChange" instead of "OnSelect" - for a dropdown, OnSelect refers to the selection of the actual dropdown control, not an item in it's dropdown list.

 

Hope this helps,

RT

Thank you for your response -I have attached a word document showing the configuration, however it will only take me to 1 of the screens no matter which one of the selections I pick. Any idea on how to resolve would be appreciated.

Thanks,

Sigi

Hi @shawkinson ,

 

This is because that you have used the Table function and that makes the screens become records in the table, so it won't be referenced to the screens inside the app. 

 

Please use below formula instead:

If(ListBox1.Selected.Value="My Open Opportunities",Navigate(ScreenListMyOpenOpps,None),
ListBox1.Selected.Value="All Open Opportunities",Navigate(ScreenListAllOpenOpps,None),
ListBox1.Selected.Value="My Won Opportunities",Navigate(ScreenListMyWonOpps,None),
ListBox1.Selected.Value="All Won Opportunities",Navigate(ScreenListAllWonOpps,None),
ListBox1.Selected.Value="My Lost Opportunities",Navigate(ScreenListMyLostOpps,None),
ListBox1.Selected.Value="All Lost Opportunities",Navigate(ScreenListAllLostOpps,None))

 

Regards,

Mona

Community Support Team _ Mona Li
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

@RusselThomas @v-monli-msft 

Thank you for your reply. I added the formula to the onChange property, however now everything is blank - Any idea why that would be?

See attached document

Thanks

Sigi

Hi @shawkinson ,

Are the items empty in the dropdown, or just the default value?

Kind regards,

RT

@RusselThomas 

The dropdown is completely blank. 

See attached

Thanks

Sigi

@RusselThomas 

The items are blank -

Thanks

Sigi

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 (11,194)