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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Muzammil_069506 292 Moderator on at

Like (2)

Report
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.

Was this reply helpful? Yes No
Rspv 37 on at

Like (1)

Report

@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?

Was this reply helpful? Yes No
Muzammil_069506 292 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Rspv 37 on at

Like (1)

Report

HI @Muzammil_069506 It doesn't work

Was this reply helpful? Yes No
Verified answer

Muzammil_069506 292 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No