Unanswered

Power Apps Auto Populate fields

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone new to Powerapps please bear with me.

I wanted to know if an auto populate functionality is possible in power apps.

So for example i have a form where in when a data encoder inputs the employee ID other fields will automatically populate with the data that is equivalent to the employee id like their name, department etc.

If its possible can someone point me to an article video tutorial or website where this is being shown?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

Yes it is possible. For example if your table name is SPList2 and columns like Title, ID, Name.
If the user enters ID in TextBox1, you can auto populate
Name as:
        LookUp(SPList2, ID= Textbox1.Text,Name )

Title as:
     LookUp(SPList2, ID=Textbox1.Text,Title)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.


Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi
Thanks for the quick response.

a follow up question.
so for example instead of the employee ID can the data encoder input a few strings as well and a drop down on the name field would appear?
heres a scenario the data encoder cant find the employee id and tried to search for a name if he types in the first name is it possible that a drop down with different possible names would as result would appear?

Was this reply helpful? Yes No
Pratrap 13 on at

Like (0)

Report
Copy link

Link copied!

Hi ohra,
There may be a better solution but I suspect you would need to use the OnChange event and some JavaScript.

Have a look at this - is this your situation?
https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/267439/auto-populating-values-based-on-a-lookup-field-in-dynamics-crm/755934

Pratrap

Was this reply helpful? Yes No
Min Rao 187 on at

Like (1)

Report
Copy link

Link copied!

suppose you have one "text input" and one "drop down", and you data source call "Employee"
set value of you "drop down" to "name" (though properties) set [items] of you "drop down" to following:

Filter(Employee, TextInput.Text in 'name')

Once you type string in text input, drop down will start to display filter result.

* and better to set text input 's DelayOutput to true in order to reduce network request call.

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Can you be more specific with your scenario
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Pratrap
Yep its he same scenario but what i have I believe is simpler.
I would have to try first the native functionality of powerapps before diving on to JS.
is this possible to apply to powerapps too the java script option?
I have not yet created an app and we are basically doing a feasibility whether we can use this than what we currently have so far.

Thank you so much for the reply i really appreciate it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Eka

Ill have to try the first one that you have suggested. to let me test first powerapps in general and probably get back here once i encounter this issue.

Thanks so much for your help

Was this reply helpful? Yes No