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.
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, LookUp( ListSrc, Station.Text = Station, Facility ) )
Issue: Expected Text value.
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 ) )
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.
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.
In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.