Answered

Search SharePoint List for a record and update certain fields

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I have a sharepoint list that powerapps patches all of the results into. I'm wanting users to be able to use powerapps to update the records for things such as Status being changed from Open to Closed or assigning to a different department e.g. Sales, Finance etc.

How do I go about doing this please? There's quite a lot of records in the sharepoint list so i'll need the users to be able to search based on the ID of the sharepoint list so that it pulls up all the different columns and what the record value currently is and then be able to edit some of the fields and patch the changes back to the sharepoint list. There's a mixture of date fields, text fields, drop down menus. I've watched several videos but nothing seems to be what i'm looking for.

Any help is much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Dave-ITMan

The usual way to accomplish this is to use a textinput box, a gallery and an edit form. The Items property of the gallery would be your list and it would be searched using a textbox. The Items property of the gallery could be:

Filter(splist, ID= Value(TextInput1.Text)) or Filter(splist, StartsWith(ID, TextInput1.Text.))

The Edit form would have the Data Source property: splist and the Item property: Gallery1.Selected

You can determine which fields are shown in the edit form by selecting them in the dropdown on the right side of the screen when the edit form is selected. You would need a button to submit the changes. The OnSelect property of the button would be: SubmitForm(Form1).

Was this reply helpful? Yes No
bcuz 2 on at

Like (0)

Report
Copy link

Link copied!

Hi I applied this solution and it partially succeded. Weird thing is the first time I open the app and put in the search ID in the text box it pulls up the records in the form. But if I go back a second time to try the same record, I get a blank form, even if I save it (I have a button to save.) Any idea why this is happening?

Was this reply helpful? Yes No