cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ame
Helper I
Helper I

Autopopulate text input

hi, i would like to autopopulate my 5 text input with the data from my dataverse, for example the user select an id into the text input and the other autofill automatically with other data

ame_0-1634019121805.png

thx

1 ACCEPTED SOLUTION

Accepted Solutions
gabibalaban
Super User
Super User

@ame ,

All you have to do is to set the default property of the text input controls with formula like:

LookUp(table, ID=IDTextInput.Text, columnToBeReferenced)

View solution in original post

4 REPLIES 4
gabibalaban
Super User
Super User

@ame ,

All you have to do is to set the default property of the text input controls with formula like:

LookUp(table, ID=IDTextInput.Text, columnToBeReferenced)

View solution in original post

did you have an example? so i need to put this in my second text input and not directly in first one?

 

i resolve thank you for the help

 

@ame ,

Yes, in the Default property of each TextInput(except the one TextInput1 in my formula where the user will insert the ID) use:

If(IsBlank(TextInput1.Text),"",LookUp(DataVerseTable,ID=Value(TextInput1.Text),YourColumnName))

 I used a if sentence to exclude the situation when the ID TextInput is empty. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,900)