Pre populating a form with Sharepoint list

(0) Share

Report

Posted on by Goat123

Hi all,

I am brand new to using PowerApps. I created a form and linked the SharePoint list to the form.

The SharePoint list is called Asset and contains the following fields :

Staff ID (Primary Field)

Name

Asset Description

The elements on the form are all text boxes. When the person enters the StaffID, I want the Name and Asset description to automatically populate the form.

I tried using the Lookup function for the default of the text box for Name but the information wouldn't pull down . Have I gone about it all wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Ismael_Novo 308 on at

Like (0)

Report

We need more information for help you. But a first approach could be this:

First(
Filter([SharepointList];
[ColumnUserMail] = User().Email)
).[ColumnTitle];

Try to catch by usermail the row you want (you also could add more criteria with the And() function) and then show in Text field. I also use a lot the OnChange function to update changes in my powerapps forms.

Was this reply helpful? Yes No
AsanKani 710 on at

Like (0)

Report
Hi, @Goat123
I think you are using Display form / edit form to display the asset information of staff.
You have enter staff id out form form using TextInputBox or label as your wish.
Form Item control to put below coding
LookUp('Asset', Staff ID=Value(TextInput.Text))
That's it. when you have enter Textinput box value of Staff ID to view the staff assets details in form

Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Was this reply helpful? Yes No
Goat123 2 on at

Like (0)

Report

HI @AsanKani and @Ismael_Novo .

Thank you for your help. One staff can have many assets so I tried to use the following filter statement onChange for a combo box.

Set(name of the variable, filter(name of Sharepoint list, Name of column in Sharepointlist=ComboBox.Selected.Result)).

The text box, I wanted to display the result of the query would not display with the results. It came back with the error that the result was incompatible with the text box. Is the filter statement wrong?

Was this reply helpful? Yes No
AsanKani 710 on at

Like (0)

Report
@Goat123 ,

You are set variable right. Variable content only one value. If you are filter like above statement is record / multiple value. So your statement is wrong.
First of, shall you share the screen image, I mean what are the controls you are use and what do you expected that control based. and SharePoint list data (sample data). we will help you.

I think you are required to display all asset information based on selected staff. Right?
And also your SharePoint Asset list having multiple record of assets with staff name like a below
ID Asset Name Asset Description Staff Name
1 AAA BBB Staff 1
2 AAA BBB Staff 2
3 BBB CCC Staff 1
But you are using form to try display to select / filter Staff 1 all assets.
My guess is right means, You are trying wrong method.
Form not display multiple records. You can go Gallery display the staff assets data / data table to display the asset data.
If you are using Gallery (data source property)/ Data table (Items property), Use filter like below
Filter(Asset SharePoint list ,Staff Email/ID=Label_Staff Email / ID.Text)

Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Was this reply helpful? Yes No