SharePoint Form New Item Lookup additional columns

(1) Share

Report

Posted on by PC-11121455-0

I have a form based on a sharepoint list with a lookup column, pulling data from another list.

When the user selects the item, I'd need the other fields to populate with their data

Am able to add the fields but there doesn't seem to be an obvious way of pulling the data back for the other fields.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
Hi @PC-11121455-0,

I am not sure whether I understand your query because I dont see complete information for your query.

I assuming that when user select an account from dropdown/combobox, you want to show its associate Account Number and Sort Code to control that you have used? If this what you are looking then the text property if you are just using Label below account number would be

LookUp(SharePointList, 'Account Name' = dropdownOrcombobox.Selected.'Account Name').'Account Number'

And the text property if you are using Label below Sort Code would be

LookUp(SharePointList, 'Account Name' = dropdownOrcombobox.Selected.'Account Name').'Sort Code'

Please try to share more supporting information for quick response.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Thanks,
ANB

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @PC-11121455-0

Adding to @ANB's comments, you can get those values after you save the record providing those controls are in the Form - their values would be
ThisItem.'Account Name:Account No'.Value ThisItem.'Account Name:Sort Code'.Value

however if you want them immediately the account is chosen, then similar to previous post (note you need to use the name of the list being looked up)
LookUp( YourLookedUpList, 'Account Name' = ComboBoxName.Selected.Value ).'Account No'

However I would add that SharePoint Lookup columns are mostly unnecessary with Power Apps and have the potential to cause you unwanted and unneeded complexity and restrictions - I have never used them. It is generally a better idea to get the required field items directly from the second list with Power Apps and write back to a Text column.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No
Verified answer

PC-11121455-0 9 on at

Like (0)

Report

Apologies, assumed the data included would be sufficient have.

On creating a new item and selecting a "Account to be debited", I'd like the Account and Sort code to be populated so the user can confirm they have the correct account.

All account information is contained a seperate sharepoint list called "Account information"

Currently account information is populated on save and is visable in the sharepoint list view and also upon viewing the saved form

Assumed I could set something in the default items, based on the account to be debited value

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

Please go back to ANB's solution (which is also mentioned in mine) as this is what you need.

Was this reply helpful? Yes No