0

I have a relatively simple scenario which I am trying to implement in PowerApps, but can't seem to make it work.

I have 2 dropdowns which source values will be from a SharePoint list with 2 columns Region and Department. Both these columns are Choice type columns

enter image description here

Department dropdown will depend on Region selected

  1. Region dropdown Items property

    Choices([@MySharePointList].Region)

  2. Department dropdown Items property

    Filter([@MySharePointList], Region.Value = ddlRegion.Selected.Value).Department

I think it filters correctly, however they are Records. As a result, the dropdown has items but are shown as empty items.

How do I retrieve the actual value of the Department for this dropdown?

enter image description here

enter image description here

thebernardlim
  • 755
  • 2
  • 10
  • 23

3 Answers3

0

When Power Apps retrieves values from Choice columns, they are returned as records like this: { Value: "Warehouse" } So my guess is that you're only missing '.Value' from the end of your formula.

mmikesy90
  • 783
  • 1
  • 4
  • 11
  • Yes that's how I understood too, however there is no value returned for ".Value". It is even marked red and Power Apps doesn't recognize such a property. – thebernardlim Apr 25 '23 at 07:20
  • Managed to find the answer in another thread https://sharepoint.stackexchange.com/questions/307470/power-apps-multiple-cascading-drop-downs-from-sharepoint-list-choices-column – thebernardlim Apr 25 '23 at 08:57
0

Department column Items Formula:

Distinct(Filter([@MySharePointList], Region.Value = ddlRegion.Selected.Value), Department.Value)

thebernardlim
  • 755
  • 2
  • 10
  • 23
0

Use below formula for Department drop down Items property:

Distinct(Filter([@MySharePointList], Region.Value = ddlRegion.Selected.Value), Department.Value)

SharePoint list:

enter image description here

Power Apps output:

enter image description here

Ganesh Sanap
  • 1,386
  • 1
  • 8
  • 18