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

How to compare two table (SharePoint) value in dropsown

Hi there,

I try to get value from two different SP list in two drop down and want to change its data when one drop down list value changed.

I have two list called ‘HR Data’ and ‘Managers’ 

In HR Data list contain below column;

  1. EmailAdd
  2. Group
  3. Approver

In Managers list contain below column;

  1. Group
  2. Manager

In canvas app there are two fields called ‘Operating Unit’ and ‘Approver’.By default when app will open those filed are auto display it’s data based on current user.

Operating Unit’>

  • Defaultselected property; LookUp(HR Data, Lower(currentUser) = EmailAdd).Group
  • Items propert; HR Data.Group
  • onChange ; If(locGroupSelected, UpdateContext({locApprover:colUsers, ThisRecord.Email in ForAll(LookUp(‘Managers’, Group = Self.Selected.Result).Manager, Email))});Reset(cmbApprover);UpdateContext({locGroupSelected:false}); );

’Approver’ >

  • Defaultselected property; locApprover
  • Default property; LookUp(HR Data, Lower(currentUser) = EmailAdd).Approver
  • items property; colUser


But my issue is when I open app it display Approver name which is coming from HR Data list. And then I change Operating Unit’ drop down then ‘Approver’ will be changed and then I refresh page without saving then ‘Operating Unit’ will be display correctly but ’Approver’ value is display on before selected value. I couldn’t get any errors or clue where is issue. 

Hope your kind support.



Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,761)