web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Changing an existing r...

Power Apps

Unanswered

Changing an existing row/data from a new form

(0) Share

Report

Report

Posted on by Kudratilla

9

Hi,

My data source consists of two columns, "Date" and "FoodName".
If I want to Edit existing information then I go to my BrowseGallery and then -> select a specific row -> and then edit it - easy.

But what if I am not coming from BrowseGallery and have not selected a specific row? What I want is a Form where I can fill in FoodName and then select a Date (and row ID if necessary) and then it replaces existing data.

Sincerely,

Kudy

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

BCBuizer 22,577 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Kudratilla,

A possibility that comes to mind uses a variable:

In the OnChange property of the field where the user can type the FoodName, set the following formula:

With({ _Item: LookUp( DataSourceName, FoodName = Self.Text )}, If( IsBlank(_Item), NewForm(FormName); Set( varEditRecord, Blank() ), EditForm(FormName); Set( varEditRecord, _Item ) ) )

Then set the Item property of the form to varEditRecord.

Since this will break the reference to the gallery, you'll need to insert the below in the OnSelect property of (a control in?) your gallery to make things work again:

EditForm(FormName); Set( varEditRecord, ThisItem );

You should be careful with this though, because any typo will create a new record and pollute your data.

Was this reply helpful? Yes No

Join the conversation