Answered

Dropdown, Sharepoint, and datacard defaults

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good Morning All,

I have been working on an app that will have a set of cascading dropdowns that pull their options from a lookup list on sharepoint, then the app writes to a different sharepoint list. The cascading section is not where I am having issues. I have the dropdowns pulling info from the lookup list properly in editor, but in a published version they will not display any options. I have found that when I have an empty sharepoint list they work perfectly, but once I have an entry in the sharepoint list the dropdowns fail. This lead me to look at the data card defaults which were set to ThisItem.MyColumn. The Column was the one that it was supposed to write back to. This default now throws an error. What should I have there? and will fixing that fix my larger issue?

My syntax in the first dropdown, which should function independent of the second one, is as follows.

Sort(Distinct(Filter(PowerApp_Tiered_Lookup, Lookup_Value_1 = "Keyword"),Lookup_Value_2),Result)

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you mean the Cascading Dropdown box (ComboBox) would not work in published app?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. As an alternative solution, please consider save your LookUp List records into a Collection, then use collection as data source in your app.

Please take a try with the following workaround:

Set the OnStart property of App to following:

ClearCollect( LookUpListOptions, PowerApp_Tiered_Lookup )

Then set the Items property of the Dropdown box to following:

Sort( Distinct( Filter(LookUpListOptions, Lookup_Value_1 = "Keyword"), // Reference collection as data source here Lookup_Value_2 ), Result )

then re-publish your app, then check if the issue is solved.

Recently, multiple users have faced same issue with you, please check the following threads:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Cascading-dropdown-values-visible-in-edit-mode-but-not-visible/td-p/592537

https://powerusers.microsoft.com/t5/Building-Power-Apps/Dropdown-list-function-did-not-work-in-published-app/m-p/591204

https://powerusers.microsoft.com/t5/Building-Power-Apps/Cascading-dropdown-issue/m-p/590050

I would post this issue to my product team, if this issue is solved, I would reply here. Please take a try with above alternative solution I provided, check if the issue is fixed.

Best regards,
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the suggestion looks like you found a similar fix to what I did.

What I needed to do was refresh my dataset on visible. Apparently the data wasn't loading properly on startup, that's why it worked if I clicked on an old entry before adding a new one. Weird error/workaround, but it seems to be working. My code on visible:

Refresh(PowerApp_Tiered_Lookup)

Thanks again. This community has been extremely helpful