AutoFill fields from excel table

(0) Share

Report

Posted on by SanchezITM

153

Hi guys,

I have an excel Table "ShopList" with 3 colums "Number"/"Name"/"email". I need 3 text fields "NumberAPP"/"NameAPP"/"emailAPP" or something like that, when I introduce a number in the first text field "NumberAPP", the other two fills automaticly with the name and the email from the table.

Any idea?

Thanks !

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yamao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi SanchezCSG,

Please consider to use Lookup function, about Lookup function, please check this documentation for a reference:
https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/

And my steps for a reference:
1. Create a connection from PowerApps to Excel table1
2. Add a Text input control, then add two Text box controls.
3. Set the Text property of the two Text box controls as LookUp(Table1,Equipment=TextInput1.Text,Status)

and

LookUp(Table1,Equipment=TextInput1.Text,Usage_x0020_Vanue).
4. Then when I enter the equipment name in the Text input control, the other value will be filled automatically.

Please try it on your side an let me know if it works for you.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
SanchezITM 153 on at

Like (0)

Report
Copy link

Link copied!

Works perfect! thank you @v-yamao-msft

Was this reply helpful? Yes No