Unanswered

How to remove or disable the DEPENDS on property for Drop down lists

Like (0) Share

Report

Posted on 27 Dec 2019 17:45:00 by MRRadiant

Recently I have started having problems with the Drop down lists ( DDL) where in EDIT forms the Value displayed in the Parent.Default though correct ( previous selected value stored in the DB . the DDL ( displays for the user different ( mostly the first entry in DDL, depends on property is used though never defined in the first place.) . this is throwing the users off as what they had selected and saved previously stored in the Database is not what is shown on the EDIT form.

WE have applications where the users selected a lot of data from DDL and and when the record is pulled up in a Edit form for editing , it should display the old data( Previous saved data from DB)

The developer does not have the ability to remove the Depends on Control or disable it. it should allow the developer to globally or at individual control level disable this feature.

While the intent is good this feature is creating havoc with already developed apps and functionality is disastrous for the EDIT forms.

Thanks

Categories:

Connecting to Data

General Questions

I have the same question (0)

All responses (9)

Answers (0)

TNM 4 on 07 Mar 2023 at 18:11:22

Like (0)

Report

Re: How to remove or disable the DEPENDS on property for Drop down lists

I am still having this issue as well. There doesn't seem to be a way to remove dependency and I'm not adding or setting any dependency in the drop downs. They're just randomly getting connected as dependent to any other drop down on the screen. Completely different and unrelated data sources being used for the drop down items. Any resolution here?

Was this reply helpful? Yes No
SLPS 46 on 30 Mar 2022 at 19:05:48

Like (0)

Report

Re: How to remove or disable the DEPENDS on property for Drop down lists

Any resolution to this? I am having this problem too.

Was this reply helpful? Yes No
SamEll 32 on 29 May 2020 at 10:11:07

Like (0)

Report

Re: How to remove or disable the DEPENDS on property for Drop down lists

I think I'm also having a similar issue - in my table SSF_LK_SSF_Scale, 1 = Large-scale and 2 = Small-scale. Although the dropdown is defaulting to the correct ID, when I change the field that is displayed to SSF_Scale (scale name rather than scale ID), it just defaults to the first option in the list. Is there a solution for this?

papps.png

Was this reply helpful? Yes No
v-siky-msft on 31 Dec 2019 at 01:46:01

Like (0)

Report

Re: How to remove or disable the DEPENDS on property for Drop down lists

Hi @MRRadiant ,

That's wired, but I think it is sporadic.
Could you replace that datacardvalue in the form by a combobox and then try again?
Sik

Was this reply helpful? Yes No
MRRadiant 12 on 30 Dec 2019 at 09:09:27

Like (1)

Report

Re: How to remove or disable the DEPENDS on property for Drop down lists

@v-siky-msft , hi appreciate your effort and help.

Its a simple Table ( back end Data source SQL server table[See attachment] ) both cases. , No filter. Nada
I just want the depends on gone , the DDL field should display the previous ( parent.default value to the end user).

from what I can make out, the Power apps tool should not display anything until something (a change) is made / or new value selected from the DDL.

Thanks

ES_Items.PNG

Was this reply helpful? Yes No
v-siky-msft on 30 Dec 2019 at 08:56:14

Like (0)

Report

Re: How to remove or disable the DEPENDS on property for Drop down lists

@MRRadiant,

Could you share the Items property of drop-down? Is there any filter function based on another dropdown selection?
'Depend on' is just a visual representation of the Item property. If the Items code satisfy the cascade, the 'Depend On' will be set.
Sik

Was this reply helpful? Yes No
MRRadiant 12 on 30 Dec 2019 at 08:23:02

Like (0)

Report

Re: How to remove or disable the DEPENDS on property for Drop down lists

Let me first answer your questions 1 - 4

1 - Parent.Default ( Employment Status and State , State works fine but Employment Status does not)
2 - They are SQL server Tables ( some of them are hard coded lists) it has no impact for me .
3 - See attached files ( screen shots) same for both DDL ( Emp Status and State Code)
4 - See attached files ( Specifically the Item property of the edit form is a lookup to that particular record on the back end DB( SQL server) it is retrieving the correct record from the back end. all other fields are ok only the EMployment status DDL is .
the Update property of both the data card are set correctly as well. (Datacardvalue.SelectedText.Value( column name from the Backend DB) this is all correct.

I believe the bug in is MS Power apps Environment, If one define a DDL field with a DB or list of values It shows the first entry on the Edit form or New form for that field.

All I an looking for a simple DDL data card without any dependency . Cascading DDL is not my need to requirement. why cant we define a independent simple DDL . while the Cascading has merit forcing it on every DDL is poor implementation by MS.

Thanks

EMP_DependsON.PNG

EmploymentDDL.PNG

Was this reply helpful? Yes No
v-siky-msft on 30 Dec 2019 at 06:08:47

Like (0)

Report

Re: How to remove or disable the DEPENDS on property for Drop down lists

@MRRadiant,

Depends on property is for cascading drop-down, that means you select an option in parent drop-down to filter options in child drop-down, so it only influences Items of child drop-down. In addition, if you apply the filter function to dropdown based on another dropdown selection, Depend on property will automatically be set. Reference: Create dependent drop-down lists in a canvas app. So it can not be disabled, if you are not making a cascading drop-down, it won't work.
You said "the form doesn't show the value stored in the Database previously ", I think this issue is mainly caused by Default property(for dropdown) or DefaultSelectedItems property (for combo box). So I hope you can provide some further details with screenshots:
1. What it the Default or DefaultSelectedItems property of drop-down?
2. Could you show the items property of dropdown? Is it a cascading drop-down?
3. Could you share the screenshots of Depend on property
4. What is the items property of edit form? Do all other fields show previous value properly?

Sik

Was this reply helpful? Yes No
Community Power Pla... on 27 Dec 2019 at 18:34:23

Like (0)

Report

Re: How to remove or disable the DEPENDS on property for Drop down lists

The Depends On property of a dropdown box only adds a filter to the Items property and uses a previous entry to filter the next dropdown.
I'm not sure the Depends On property is the issue here. It sounds like you have an issue with which record is being displayed in your Edit Form. Is that the case?

Was this reply helpful? Yes No