Unanswered

Auto fill

(0) Share

Report

Posted on by AC-30071532-0

Hello all,

I have been tasked with creating a simple request form for vacation time. It is supposed to use data from an example list in SharePoint, which I've attached to this post. I have to get certain fields to autofill (job title, employee id, and email) after typing in the name of the user.

I created a new screen, then inserted a form using my SharePoint list, and the app is created. However when I go to run it, the user combobox lists random numbers and not my name. What can I do to fix this? And how can I get the rest of the information to autofill? I've tried writing different formulas and looking up ways on how to do it but I'm new to this and at a loss. Any help is appreciated. Thanks!

Categories:

Building Power Apps

apprequest.png

sharepointlist.png

I have the same question (0)

All responses (4)

Answers (0)

Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (0)

Report

HI,

Show us your code, that image doesn't help to resolve your issue.

What ComboBox? On the Form? on the screen?

Please show the Default / Text / DefaultSelectedItems / Items properties of the controls,

Show us the code of what you are trying to use to get the user etc.

Curious, you said you are using a Form for the list, but Galleries are usually used for listing things from a list.

What is the form doing? How are you assigning the Item assigned to the Form?

Was this reply helpful? Yes No
AC-30071532-0 6 on at

Like (0)

Report

In the new screenshot I provided, I circled the buttons I used that made a form which autogenerated fields based on the fields in my list on sharepoint. The screenshot also includes the DefaultSelectedItems properties as well as the Items code for the combobox in the user field. The Default property for the User card is ThisItem.User. As for the different codes I have tried, I have tried a lot since I've been working on this form the last 2 days and that would be a lot to list here.

I'm not sure why the app autogenerates the form to where the User section uses a combobox to find a specific user. I tried changing it to a regular text box for users to type in their name, but I couldn't figure out how to make that work.

I tried using a gallery like you suggested but that was not working at all.

The goal I have for this form is to have the user enter their name, which will autogenerate other fields on the form such as their email, ID, etc.

Was this reply helpful? Yes No
Suggested answer

venturemavenwill 1,189 Super User 2025 Season 2 on at

Like (1)

Report

The modern component combo box doesn't appear to automatically select the right field for "People" fields. Try manually selecting "Display Name"

Was this reply helpful? Yes No
AC-30071532-0 6 on at

Like (0)

Report

Thank you @venturemavenwil. That solved the issue for the combobox. Now how can I get the other fields to autofill after the user picks their name?

Was this reply helpful? Yes No