Disable DependsOn for DropDown

(0) Share

Report

Posted on by Axal

945

Hi guys,

How to remove/disable Depends On for Dropdown list ?

I created an Apps using template, and at one of its data card, I added a dropdown, but this is supposed to not link to any other control, but this "Depends On" link it to another control.

I saw some thread to be honest, but is there an easy explanation to it ? I'm not a really techie nor developer.

It is something like this :

The one named "ddCustomers" is my addition dropdown. which supposed to only get data from my 2nd datasource. But when I look into its property, it has Depends On and when I take a look, like this :

I don't need this link, but cannot find how to disable it.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Axal 945 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi guys,

Ok, it seems that "Depends on...." actually means no dependency. The problem was actually my dropdown "Items" property, turns out cannot use ShowColumns function.
Thanks.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Axal ,

Would you like to populate a Dropdown control with custom items?

If so, as per the column type of the column value that you would like to display as selections, there would be different ways to achieve your need. Please refer to the official doc to learn more:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-drop-down#list-from-a-data-source

Key properties of this control:
Items – The source of data that contains the items that appear in the control. If the source has multiple columns, set the control's Value property to the column of data that you want to show.
Value – The column of data that you want to show in the control (for example, if a data source has multiple columns).

If it is a Choices or LookUp type column, you could leverage the Choices function to retrieve selections directly.
Choices(DataTable.ColumnName)
Please refer the doc:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-choices#syntax

Otherwise you will need to use the Distinct function to retrieve distinguish values as selections from existing values of the column in the data source:
Distinct(DataSource, ColumnName)

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Axal 945 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni ,

I'm sorry, I kinda confuse now (after take a look at that doc as well). It is said that Items is for the source, and when it is multiple, we must specify in Value which column we want to display, right ?

Well, the thing is, I want to display 2 columns, can this be set ?
So my Items property is something like this:
What I really want is these two column appear in my dropdown.
What I see now in Value is :
Obviously, based on the doc as well, we need to select one, cannot choose both.

Any trick how to display more column ? but still the return value, I need the 1st column though, I'm not sure how to handle it also.
Thanks.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Axal ,

You could use Combo Box instead.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-combo-box#description

Using a Combo Box you could change its layout to display double columns in selections:
With this layout, you will be able to select primary column and secondary column to display together as one selection but only show primary column value as selected items.

Please have a try.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No