SharePoint - custom PowerApps form - automatically pull data from lookup fields to the form

[xsomej]

Hi all,

is there a way how to pull data automatically to the custom PowerApps form SharePoint lookup fields?

I have a field Cost Description, which is a lookup field, and that's also pulling another fields from that list:
Budget Code
Cost Type
Local Code

I have those fields in the form, but I want the user to select only the Cost Description and update the other fields automatically:

Those fields are populated after the user submits the form to the SP list.
But is there any way how to update them automatically in the form?

[RandyHayes]

@xsomej 

Make sure you have the 'Cost description' list in your datasources in the app.

Set the Items property of the combobox (assuming your control in the datacard is a combobox) in the Form to : 'Cost description'

Set the DefaultSelectedItems property (if it's a combobox) to: 

    LookUp('Cost description', ID=ThisItem.'Cost Descripition'.Id)

For your other datacards, just reference the combobox.  For example if your combobox is called DataCardValue1 then in your label (or whatever you have) in your Cost Type datacard, set the Text to DataCardValue1.Selected.'Cost Type'

Do the same on the others and adjust for their column names.

I hope this is helpful for you.

[xsomej]

Hi @RandyHayes,
I'm using the predefined SharePointForm fields, so the Cost Description is working just fine (DefaultSelectedItems is set to Parent.Default). And yes, those are comboboxes.

But I'm looking for a way how to pull those other three columns from SP based on what user selects in the Cost Description drop-down. It get updated after he submits the form, but not while having the form in edit mode.

[RandyHayes · Accepted solution]

@xsomej 

Yes, I understand.  The problem is that the Default form will bring that combobox in with a Choices formula on the Items property.  This will NOT supply the additional information that you want.

So, as I mentioned in last reply...that is how you work around it.

Otherwise, you will need to do a lookup on all of the other places that you want data:

i.e   LookUp('Cost description', ID=yourCombobox.Selected.Id, 'Cost Type') and etc for the others.  That can get tedious, but would work as well.