cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ianallen13V2
Helper II
Helper II

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

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.  

 

example 1.jpg

 

 

 

 

 

 

 

 

 

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? 

22 REPLIES 22

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_0-1632322124863.png

 

 

 

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. 

 

ianallen13V2_1-1632322313174.png

 

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.

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Thanks Bryan, 

 

This is what I see: 

 

ianallen13V2_0-1632323011624.png

 

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

ianallen13V2_1-1632323116242.png

 

And then one step backwards: 

ianallen13V2_2-1632323194150.png

 

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
Super User
Super User

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

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

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? 


@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!

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
ianallen13V2
Helper II
Helper II

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

ianallen13V2_2-1632324366249.png

 

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

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. 

 

ianallen13V2_3-1632324924776.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,857)