LookUp in PowerApps New Form

(0) Share

Report

Posted on by martatracik

297

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

martatracik 297 on at

Like (0)

Report

i saw some solution for Gallery View , but never for forms.

Was this reply helpful? Yes No
martatracik 297 on at

Like (0)

Report
if this is not possible, i thought maybe about Summary Screen? User will see summary of his request that will be a Gallery View with Lookup for these two fields?then maybe i can use:
LookUp('RequestsVLU','Bank Account Number:'=thisItem.'Bank Account Number:', 'Bank Name')
Am i correct?

Was this reply helpful? Yes No
martatracik 297 on at

Like (0)

Report
the problem that i face with that formula is that neither
'Bank Account Number:'
and
'Bank Name'
are not recognized.

Was this reply helpful? Yes No
Verified answer

martatracik 297 on at

Like (0)

Report

i resolved accordin to that video of Raza Dorrani
https://www.youtube.com/watch?v=Qzpjq008cBY

Was this reply helpful? Yes No