Text Input to Auto-fill Fields from SharePoint List

(0) Share

Report

Posted on by Wobblybeard

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

zmorek 3,272 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Wobblybeard 6 on at

Like (1)

Report
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, LookUp( ListSrc, Station.Text = Station, Facility ) )

Issue: Expected Text value.

Was this reply helpful? Yes No
zmorek 3,272 on at

Like (0)

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

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

Was this reply helpful? Yes No
Wobblybeard 6 on at

Like (0)

Report

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.

Was this reply helpful? Yes No