Problem with Depends On

[kingslowpoke]

Hi,

I am building a powerapps to be used in logging hours as expense to project. I would like to have project sorting based on account (customer) selected. I tried doing it with the new depends on function  but to no avail.

All help is much appreciated. 

Current filter is: "Filter(Projects, Customer = DataCardValue6.Selected.Value)" DataCardValue6 being the dropdown menu for account. Both dropdowns fetch data from dynamics in form edit mode.

App layoutDepends on filterDepends on selection

[GarethPrisk]

You appear to have it coded correctly. I have replicated this with a similar scenario of an Account form. There, I made the Primary Contact lookup filter based on the Parent Account, which was set in another drop-down on the form.

In my example, I have

• Form with Accounts as source, mode as New
• Added Parent Account and Primary Contact fields to form
  • Combo box DataCardValue4 = Parent Account
  • Combo box DataCardValue6 = Primary Contact
• Using the form Depends on functionality, the Studio generated (as expected)
  • Items property for DataCardValue6 set as below
  • Filter(Contacts,'Company Name' = DataCardValue4.Selected)
  • Shows delegation warning, and no records are shown in the drop-down
• That same filter criteria works when applied to the following controls; meaning the subset of records are shown as expected
  • Data Table, as the Items property
  • Combo box, as the Items property

I even tried to paste the standalone Combo box into the data card, but it stopped behaving properly. This seems to be a bug...

The resolution is to update the source to include the disambiguation operator.

Filter([@Contacts],'Company Name' = DataCardValue4.Selected) for my example.
Filter([@Projects], Customer = DataCardValue6.Selected.Value), for your example.

However, this may introduce some unintended consequences. While it does maintain the Parent Data Card's properties, it does appear to automatically set the value when the dependent lookup it set. You'll need to tweak the other properties, in order to control the intended behavior (such as clearing the Project lookup entirely, when the Customer value is changed).

[kingslowpoke]

Hi and thank you for your message. 

Problem however still exists.

I updated the formula to the following: Filter([@Projects], Customer = DataCardValue6.Selected.Value), but when account is not selected, it does not appear empty (shows the normal project list), and selecting account does not have any effect to that. 

I have tried refreshing the app, but that did not help. I have hard time understanding the ".Value" part of the formula does it just return the selected value, or does it have some another function? 

EDIT: I manually updated the whole formula, and now the dropdown is empty, but selecting account doesn't bring up any values either.

[v-yutliu-msft]

Hi @kingslowpoke ,

Do you want to filter a list based on the selection of a drop down?

Could you tell me

1)the data type of Customer field?

2)the data type of account field?

3)the drop down's Items?

You need to make sure"Customer" field and "DataCardValue6.Selected.Value" being the same data type.

Best regards,

[kingslowpoke]

---

@v-yutliu-msft wrote:

Hi @kingslowpoke ,

Do you want to filter a list based on the selection of a drop down?

---

This is correct.

Account is Lookup inside Expenses related to Account entity. Inside Account entity Data type is unique identifier.
Customer is lookup inside Projects that is related to same Account unique identifier.

For the dropdown items: Account items are customer names and projects are project names. 

[GarethPrisk]

Slight correction on what I recommended: Filter([@Projects], Customer = DataCardValue6.Selected

As you pointed out, the value property isn't applicable here. Not sure I made bad copy pasta with your original or what - sorry.

Also, you can set the Project data card to be hidden if/when Account value is blank, and even reset it.

• Set Visibility property on Project data card to !IsBlank(DataCardValue6.Selected)
• Also for the OnChange of DataCardValue6, set OnChange property/function to Reset({Project Data Card Value})

[kingslowpoke]

@GarethPrisk 

Hi,

I tried these, but the project field still stays empty unfortunately. Is there an easy way to check which values it is trying to compare?

Project now: Filter([@Projects], Customer = DataCardValue3.Selected (DataCardValue3 is the new account card)
Account: OnChange: Reset(DataCardValue7)
Project Visible: !IsBlank(DataCardValue3.Selected)

[v-yutliu-msft · Accepted solution]

Hi @kingslowpoke ,

I need to know the formula that you use in Account drop down's Items?

If you set datacardvalue6's Items:  Account

Then please set the project's Items:

Filter(Projects, Customer = DataCardValue6.Selected)

But if the   set datacardvalue6's Items is not Account, the formula is different. So I need the settings in details.

To compare data type, using collection is a good way.

Save value in collection, you could see its structure.

Only the data that you want to display is the same structure with the data source, it will display correctly.

Best regards,