Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

SharePoint Form New Item Lookup additional columns

(1) ShareShare
ReportReport
Posted on by 9
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:
  • WarrenBelz Profile Picture
    WarrenBelz 145,343 on at
    SharePoint Form New Item Lookup additional columns
    Please go back to ANB's solution (which is also mentioned in mine) as this is what you need.
  • Verified answer
    PC-11121455-0 Profile Picture
    PC-11121455-0 9 on at
    SharePoint Form New Item Lookup additional columns
    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

  • WarrenBelz Profile Picture
    WarrenBelz 145,343 on at
    SharePoint Form New Item Lookup additional columns
    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
  • ANB Profile Picture
    ANB 7,060 on at
    SharePoint Form New Item Lookup additional columns
     
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard