Showing results for 
Search instead for 
Did you mean: 
New Member

Text Input to Auto-fill Fields from SharePoint List

Hi there.


In short:

I am trying to update an existing form into a Power App to centralize requests. I am looking to have multiple form fields auto-fill data (pulled from a SharePoint list) when the user enters data into a target field. I have been researching how to do this and I am clearly missing something terribly simple.


The user enters a number into Field A (manual or dropdown), Fields B, C, D, etc, are autofilled from the corresponding List row entered into Field A.


Column types are different. Any advice or direction would be much appreciated.

Super User
Super User

Your basic formula will be something like:

LookUp(ListToLookUpFrom, FieldA.Text=ColumnA, ColumnToReturn)

Depending on column types and data types, that formula will vary. This will help you: Filter, Search, and LookUp functions in Power Apps - Power Apps | Microsoft Docs

Thank you for your reply. That was the first doc I went through.


With a little more detail, for testing I have two fields: Station and Facility. I want Facility to load corresponding row data from the Facility column of ListSrc when a user enters a numerical value into Station. I have the following on the Default property of the Facility_DataCard/FacilityInput field. Tested also on the Facility_DataCard itself, but the error persists.:


If(Form.Mode = New,
    Station.Text = Station, Facility


 Issue: Expected Text value.

Super User
Super User

Is Facility a choice column? Is Station a number column? If both are true, you might need something like this:

If(Form.Mode = New,
    Value(Station.Text) = Station, Facility.Value


Apologies, I misspoke in my initial post. I didn't create the initial List and it has a numerous columns, so I'm not partial to changing column formats or settings. The column types vary, but both Station and Facility are single line text. The user input for Station would be a number (123) and Facility would return a string. My thought is that despite Station reading a number, it would still read it as text.

Helpful resources

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (3,426)