Thank you for visiting my site!

Home / PowerApps - Forms / Second DataSource for a DropDown

Second DataSource for a DropDown

  • Bring in the second Datasource: Data -> Connectors -> Select type ->  Fill in required selections.
  • Change your form, text box to dropdown.
  • Advanced Unlock
    ——————————————————————–
  • Items – Data source: Bring in the Data source for Items
    Change from ‘Parent.AllowedValues’ to Datasource Name
    or
    Distinct(DatasourceName, ColName)
    Sort(Distinct(DatasourceName, ColName),Result)
    SortByColumns(‘Zebra-Colors’.ColourName, “ColourName”)
    ———————————————————————-
  • Update: Select the datacard – Update:
    DataCardValue20.Selected.Value
    TO
    DataCardValue20.Selected.Result (column name)
    ————————————————————————-
  • Default: Select the dropdown and change from’ Parent.Default’ to:
    If(EditForm1.Mode = FormMode.Edit, Parent.Default, ” “)

ADD YOUR COMMENT