Lookup field from one text input to another, from different SharePoint lists - cascading auto-fill data entry?

(0) Share

Report

Posted on by rhiheu

235

Hi! This is my first post in this forum, all help appreciated 🙂

I would like to be able to type a value in the 1st text input field (e.g. username), then have it auto-populate the 2nd text input field (e.g. email address) with a value from another column in it's matching SharePoint list item. If the text doesn't match a record, the 2nd text input field remains blank until it matches a record.

After that's complete, I would like to basically repeat that process but pulling in data from another SharePoint list. So a 3rd text input field (e.g. postal address) basically monitors what is auto-filled (or typed) into the 2nd one above, then returns a value from the different SP list. If no matching entry found, it remains blank.

Hopefully that's possible? Can anyone please tell me how to do this? I've attached a screenshot too if that helps.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Try this formula on the default:
LookUp(SPListAnalyst,FullName=User().FullName,EmailAddress)

Change the EmailAddress for all other TextInput you want to Auto populate example:
LookUp(SPListAnalyst,FullName=User().FullName,TelNumber)

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
rhiheu 235 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for the slow reply - this works perfectly, thank-you!!
rhiheu 235 on at

Like
a
(0)

Report
Copy link

Link copied!
I have dug a little deeper and found actually this isn't quite what I'm after sorry. I don't think username was the best example from me - what if it's a straight text input field, not a variable you have access to elsewhere. E.g. user types in someone's nickname in the 1st text input field, what would be be the formula for:
The 2nd text input field e.g. email address to be auto-populated from another column in the same SharePoint list
The 3rd text input field e.g. postal address to be auto-populated from a different SharePoint list, based on the content in the 2nd text input field.

Thanks for your help.