Answered

Load default value for textbox from another Sharepoint Lists

(1) Share

Report

Posted on by Rspv

How to load the default value for Control text on the Form from another SharePoint list every time the form is opened.

I create a travel Request form (DataSource: SharePoint lists:TravelRequestLog) with textbox Travel Phone Number (txtUserPhone). I want the default value of txtUserPhone to be loaded automatically from the PhoneNumber column in the word DataSource: SharePoint lists: UserDefaultInfo. How to set like that?
Really appreciate your help and Kudos for the advice.

All responses (5)

Answers (2)

Verified answer

Muzammil_069506 292 Super User 2025 Season 1 on at

Like (1)

Report

Re: Load default value for textbox from another Sharepoint Lists

Hi @Rspv the entire thing in [] please defaultselected of combobox expects you to give your value in table format
Rspv 37 on at

Like (1)

Report

Re: Load default value for textbox from another Sharepoint Lists

HI @Muzammil_069506 It doesn't work
Muzammil_069506 292 Super User 2025 Season 1 on at

Like (1)

Report

Re: Load default value for textbox from another Sharepoint Lists

@Rspv please place the formula within your Square Braces []
Rspv 37 on at

Like (1)

Report

Re: Load default value for textbox from another Sharepoint Lists

@Muzammil_069506 @@ Thank you for your advice. It works well
I did the same for combobox by set defaultSelectedItems = Lookup(UserDefaultInfo, Email = User().Email).Location (location is Choice type)
But it didn't work. Could you please help?
Verified answer

Muzammil_069506 292 Super User 2025 Season 1 on at

Like (2)

Report
Re: Load default value for textbox from another Sharepoint Lists

Hi @Rspv

Here's how you can set a default value that updates every time your form loads from a different list:
1. **Unlock the Data Card**: In the PowerApps studio, select the form and then the data card you want to modify. In the properties pane on the right, click on the lock icon to unlock the data card.
2. **Modify the Default Property**: Select the TextInput control inside the data card. In the properties pane, find the 'Default' property.
3. **Write the Lookup Function**: In the 'Default' property, write the following formula:

Lookup(UserDefaultInfo, Email = User().Email).PhoneNumber

This formula will look up the 'UserDefaultInfo' list (or data source), find the record where the 'Email' field matches the current user's email, and return the 'PhoneNumber' field from that record.
Please note that 'UserDefaultInfo', 'Email', and 'PhoneNumber' should be replaced with the actual names of your data source, email field, and phone number field, respectively.
Also, make sure that the user has the necessary permissions to read the 'UserDefaultInfo' list.