Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

update form field based on dropdown value - data in second list

Hello, I have a form where user must select a country, then I would like to update automatically the supervisors names in a field on the same active form -- the data for supervisors is stored in a separate list which also has a country column.


Currently I have the supervisors field (people picker type) set as the following:


Filter('Portal Users', 'Supervisors' = DataCardValue2.Selected.Value) -- however  the "=" is showing as invalid.  


What is the best way to accomplish this? Many thanks!

Dual Super User III
Dual Super User III

Is the Supervisors column a People/group column in SharePoint?  If so then you are trying to compare the data card value to an object, not a string.  you need to use the property from the Supervisor's column that is equal to the selected value.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,963)