The second dropdown list can not show the values?

[xyzzyx666]

I have made two dropdown to test the cascading.But the second one is not worked.

The data source is comes from SP(as the screenshots shows).

Then the app:(as the screenshots show)

 Dropdown20_region.Items:'20181210List Region';

 Then Dropdown21_department.Items:Filter('20181210List Department', Region.Id = Dropdown20_region.Selected.ID)

 And the "=" it marked red and no value can be selected in this dropdown list. No matter add Id OR NOT,

Filter('20181210List Department', Region = Dropdown20_region.Selected.Value) also not correct.

Then I try to turn off the "Explicit column selection" option and "Improved app rendering (final validation)" option within the Advanced settings of App settings. The issue is always exists.

 Many thanks for your suggestions.

[Drrickryp]

Hi @xyzzyx666,

Are any of the columns that you are using for filters Choice or Lookup type?

[xyzzyx666]

Hi @Drrickryp

Yes the second list department's region's type is look up, the Region is from the first list.

[xyzzyx666]

Hi @Drrickryp,

I have checked the property of the two dropdowns, I think the issue is because of this. But I don't know why it will generate the value:ComplianceAssetId Automatically when I input Filter in the Items and how to change it. Its color is grey. Could you give some suggestions. Many thanks!