On a SharePoint site I have several lists, below with their columns:
DEPARTMENTS
Department
ROLES
Department (lookup from DEPARTMENTS)
Role
APPROVERS
Department (lookup from DEPARTMENTS)
Role (lookup from ROLES)
Name
E-mail
I used PowerApps to edit the APPROVERS form, so that Role will be a dependent dropdown from ROLES based on the value from APPROVERS.Department.
With connections to APPROVERS and ROLES, after a lot of fidgeting I found a syntax that the Items field of the dropdown accepts: "Filter(ROLES,Departament.Value=DataCardValue1.Selected.Value)", where DataCardValue1 is the default ComboBox for APPROVERS.Department. This still throws up a warning about large data sets.
My problem now is that using the live form for a new item in APPROVERS, I select a Department, and the Roles dropdown return the correct number of items, but they are all blank. I have attached a screenshot that illustrates the issue, names are in Romanian.
I'm a complete beginner at what I'm trying to do, and I lack the knowledge to even begin to understand why I get a populated, blank dropdown.
