How to make a dependent field from another drop down (while using a SharePoint list as a data source)

[ianallen13V2]

Hello, 

I am trying to figure out (and I'm sure it's an easy one for this group) how to create dependent field based on a drop down.  

My situation is this, I have two fields.  The first is a drop down called 'representative' and depending on what is selected, I want to the corresponding manager's name to populate in the 'manager' field which is a text field.  

I figured out how to do this with an excel spreadsheet as a source, but I want to move away from that and use a SharePoint list, so I have all the data in my SharePoint list, but for some reason I am having an issue on how to get this to work.  

My SharePoint list has the columns Manager, Representative, and the SP list is called 'Specialist List' - so just not sure what I am missing.  Thought that this would be an easy conversion? 

[ianallen13V2]

Thanks Bryan, but that did not work either.  It says the Name isn't valid.  The identifier isn't recognized.  I took out the 'Value' as well after selected to see if that would work - sadly it didn't.  The drop down for this QA form is Reg_Ops_Rep_Drop_Down.  Any other ideas?  

[ianallen13V2]

Hello, 

I hovered over it and it says incompatible types for comparison.  I have a few QA forms that I am trying to do this with, so that is why the drop down is a different name than previous.  I want to move away from the excel tables that I have and just use the 1 SP list instead. 

[BCLS776]

OK, a mismatched type makes sense when .Value is not the correct way to reference this dropdown.

If you back up the typing of "Reg_Ops_Rep_Drop_Down.Selected" so that Intellisense suggests some things other than .Value, what do you see? Alternatively, please share what's in the Items property for that dropdown and we can figure it out from there. I'm confident we're almost at a solution for your situation.

[ianallen13V2]

Thanks Bryan, 

This is what I see: 

And then when I go back farther - I see that I've got a compatibility error: 

And then one step backwards: 

[ianallen13V2]

Would it make any difference if the manager field in SP was a choice field and not a set as 'single line of text?' 

[BCLS776 · Accepted solution]

Just for a try, replace Reg_Ops_Rep_Drop_Down.Selected.Value with Reg_Ops_Rep_Drop_Down.SelectedText.Value - that's an older, deprecated syntax, but it may work.

If that doesn't work, please do share your Items code for the drop down

[ianallen13V2]

OMG - that worked!!  Thank you!!  And why did it work if you mentioned that it was older syntax?  What does that mean for my app? 

[BCLS776]

---

@ianallen13V2 wrote:

OMG - that worked!!  Thank you!!  And why did it work if you mentioned that it was older syntax?  What does that mean for my app? 

---

This is a weird one. I can't get the old syntax to work when I test it in my environment, but for some reason, it works for you. SelectedText was deprecated long enough ago that this should not be a regional difference between how Power Apps works for the two of us. Might be worth launching a support ticket with Microsoft on this one, because at some unknown point they may completely disallow the old syntax and then your app will stop working properly. At least you'll know the new syntax too, so it should be a quick change for you.

Anyways, glad to see you're moving ahead!

[ianallen13V2]

So now I'm trying to apply this other fields and I get this: 

 Wouldn't I be able to do the same thing just a different field? 

[ianallen13V2]

Sorry - I put the wrong field, but now I'm trying to just have it do the same thing with looking up the manager's email address.