Answered

Same table lookup - list box working dropdown not working

(0) Share

Report

Posted on by shawkinson

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

Dropdown versus L...

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

RusselThomas 4,014 on at

Like
a
(0)

Report
Copy link

Link copied!

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
shawkinson 76 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Drop down not wor...
Verified answer

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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
shawkinson 76 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Formual for dropd...
RusselThomas 4,014 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @shawkinson ,

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

Kind regards,

RT
shawkinson 76 on at

Like
a
(0)

Report
Copy link

Link copied!

@RusselThomas
The dropdown is completely blank.
See attached
Thanks
Sigi

Dropdown blank.docx
shawkinson 76 on at

Like
a
(0)

Report
Copy link

Link copied!

@RusselThomas
The items are blank -
Thanks
Sigi