Using Text Input Field to search Gallery and populate Edit Form

(0) Share

Report

Posted on by TimDemma

113

Hello PowerApps wizards,

I am trying to use a Text Input field (TextInput4 / Green Box) to filter a Gallery that is tied to an Excel sheet (Table1 / Blue Box) - (successfully did this) but now I'd like to be able to click on the arrow next to the users name that I searched for and populate an Edit Form (Salmon box) in order to update or delete certain data found in the row of the Excel sheet that the I am referring to in the Gallery. (hopefully that makes sense).

I'm thinking the arrow in the gallery can set a variable for an ID in order for the Edit Form to look for that ID to locate the row of data I am looking for to fill in the form items. But seem to be struggling.

HELP! 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@TimDemma

On the OnSelect action of your arrow icon, put the following formula:

Set(glbCurrentRecord, ThisItem)

Then change the Item property of your form to: glbCurrentRecord

Also, from what I see in the picture, you need to connect your form to the datasource.

I hope this is helpful for you.

Was this reply helpful? Yes No
TimDemma 113 on at

Like (1)

Report
Copy link

Link copied!

Thanks Randy! That worked beautifully!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@TimDemma

Excellent!!

Was this reply helpful? Yes No