Search a record from another list

%3CLINGO-SUB%20id%3D%22lingo-sub-1748852%22%20slang%3D%22en-US%22%3ESearch%20a%20record%20from%20another%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1748852%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20someone%20please%20help%3F%3C%2FP%3E%3CP%3EI'm%20trying%20to%20make%20a%20purchase%20form.%20I%20made%202%20SharePoint%20lists.%20One%20keeps%20approvers%2FManagers%20for%20each%20Affiliate.%20The%20affiliate%20column%20is%20Text%20and%20Approvers%20are%20Person%20type.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EThe%20second%20list%20is%20the%20Purchase%20list.%20and%20I%20need%20to%20get%20managers%20from%20the%20first%20list%20based%20on%20affiliate.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EI%20try%20to%20get%20the%20first%20user's%20manager%20like%3A%20Office365Users.Manager(Office365Users.MyProfile().UserPrincipalName)%20or%26nbsp%3BOffice365Users.Manager(User().Email)%3C%2FP%3E%3CP%3EThat%20doesn't%20work.%20I%20want%20to%20set%20it%20as%20DefaulSelectedItems%20for%20'Approval%20Manager'%3C%2FP%3E%3CP%3EThen%20I%20want%20to%20use%20the%20first%20list%26nbsp%3Bto%20find%20the%20other%20managers%20and%20set%20them%20as%20DefaulSelectedItems%20for%20'Approval%20by%20CEO'.%20If%20it%20was%20blank%2C%20then%20the%20user%20should%20add%20it%20manually.%26nbsp%3BI%20tried%3CBR%20%2F%3EScreen%20-%20OnVisible%20%3A%20Set(Affi%2COffice365Users.MyProfile().Country)%3CBR%20%2F%3EDefaulSelectedItems%20%3A%20LookUp('Affiliate%20Order%20Approvers'%2CAffiliate%3DAffi%2C'Approver%202')%3CBR%20%2F%3EBut%20it%20doesn't%20work%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20someone%20advise%3F%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1748852%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi,

 

Would someone please help?

I'm trying to make a purchase form. I made 2 SharePoint lists. One keeps approvers/Managers for each Affiliate. The affiliate column is Text and Approvers are Person type.

 

The second list is the Purchase list. and I need to get managers from the first list based on affiliate.

 
 
 
 

I try to get the first user's manager like: Office365Users.Manager(Office365Users.MyProfile().UserPrincipalName) or Office365Users.Manager(User().Email)

That doesn't work. I want to set it as DefaulSelectedItems for 'Approval Manager'

Then I want to use the first list to find the other managers and set them as DefaulSelectedItems for 'Approval by CEO'. If it was blank, then the user should add it manually. I tried
Screen - OnVisible : Set(Affi,Office365Users.MyProfile().Country)
DefaulSelectedItems : LookUp('Affiliate Order Approvers',Affiliate=Affi,'Approver 2')
But it doesn't work again.

 

Would someone advise?

Regards

0 Replies