How to compare two table (SharePoint) value in dropsown

[ShriniA]

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.