hi, i need to move from Excel to PowerApps interactive form. Form that will help users to submit request of Payment.
In previous Excel form they were using VlookUp function to avoid typo errors in Bank Account Name and Bank Name fields (once Bank Account Number field was selected - Bank Account Name and Bank Name fields were populated automatically).
I am wondering if i can use LookUp function in PowerApp to obtain the same.
i have two Share Point lists:
Requests - where new records will be saved and new form is connected,
RequestsVLU - where sits all bank information
now i want to lookup Bank Account Number column from Requests with Bank Account Name and Bank Name column from RequestsVLU.
