Basicaly, I want to make a form where some of the fields (name, job title, department, etc) will be autocompleted so the user won't have to complete them by hand.
Based on the full name, I want other fields to populate automatically. Can that be done? I'm using a "Person or Group" type of column for the name, so you can search users and don't make mistakes mispelling names, etc.
Hi @Anonymous ,
Are you using forms or galleries?
You might need to add the Office365 connection for this.
OnStart Property of the app:
You can use the codes below on your fields:
On the field you want to be automatically populate you need to add this:
Please check this link.
I'm using forms.
I don't need to get my profile (or the profile of the user who's filling the form) but rather get the profile of another user (selected in a dropdown).
Anyone can fill this form and input another user's data. I need to populate the fields with that user's data.
Example, I'm logged in with my Office 365 profile, I'm Lucas, but I need to fill the form for Justin, so I need the fields to auto populate with Justin's information without me having to type it in.
As @K-A-R-L said, you can use the Office365users connector. So when you want to receive the info from a user with the e-mail firstname.lastname@example.org, you would use the formula:
Problem is, not everyone knows the email of the other user.
Despite that, I tried using the email, so I created a text input field where the user types the email, and used the following formula in the other fields I want to populate:
It detects the email, but the result of the flow is 404. Doesn't seem to be working.
Hi @Anonymous ,
I can give you a better solution instead of using dropdown try the Office365Users.SearchUser function.
Please watch this video.
I added a gallery and a searchTextInput to search for Office365 users that will automatically populate the forms:
You need to unlock all the data card value:
Set the Default of each Datacard values to corresponding data field that you want:
e.g On Department Datacard Default Property:
If(Selected = true, SelectedDepartment)
Let me know if you're having trouble.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.