Hello,
Hello,
A possible solution would be to make two collections of people in each department, example: 'ColDept1' and 'ColDept2'
Then add the "Change department" button and put in its onselect:
With({
MeInDept1 : Lookup(ColDept1,Email=User().Email),
MeInDept2 : Lookup(ColDept2,Email=User().Email)},
If(IsBlank(MeInDept1) , false,
Collect(ColDept2,MeInDept1);RemoveIf(ColDept1,Email=User().Email);Patch(Source,ThisItem,{Dept1 : ColDept1,Dept2 : ColDept2}));
If(IsBlank(MeInDept2) , false,
Collect(ColDept1,MeInDept2);RemoveIf(ColDept2,Email=User().Email);Patch(Source,ThisItem,{Dept1 : ColDept1,Dept2 : ColDept2}))
It's a draft, you'll proabbly need to adjust some () 😁
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.
