Unanswered

Form correctly showing data but not correctly updating

(1) Share

Report

Posted on by JH-21011352-0

Hi all,

I have a form that is filtered by a dropdown (Dropdown1) and a Gallery below it (Gallery1).

The form on the right has text

"Currently Editing : " & Gallery1.Selected.Name & " - " & Gallery1.Selected.Attribute
 
This works as expected and respects both filters. Note, "Name" is confusing as it's the field in my dropdown, but also the first Attribute.

The form also respects this (as you can see PBI appears under Original Value, and also under Name on the left, as it should.

I then have a field for Revised value, that should update a column in my excel.

This form updates correctly based on the Gallery1.Selected.Attribute but not correctly based on Gallery1.Selected.Name

I.e. here I have selected Name: Power BI, and Attribute: Name, but if I update the Revised value, it will populate the Attibute:Name of the first Application it finds (Not Name: Power BI).

I've tried changing the OnSuccess of the form to

Gallery1.Selected.Name && Gallery1.Selected.Attribute
 
But still no luck. Any suggestions would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

JH-21011352-0 12 on at

Like (0)

Report
Copy link

Link copied!

Finally fixed it.

I had duplicate __PowerAppsId__ which was causing it to update based on the first one it could find.

Was this reply helpful? Yes No
JH-21011352-0 12 on at

Like (0)

Report
Copy link

Link copied!

@Kalathiya

The strange thing is that this doesn't fix it, it still updates the first record with the matching Attribute, but not Name.

I've tried

LookUp(

AppOwners, //ExcelTable - Replace with your table name

Name = Dropdown1.Selected.Value &&

Attribute = Gallery1.Selected.Attribute

)

and no luck. It's odd because the text seems to work fine.

Was this reply helpful? Yes No
Kalathiya 918 on at

Like (0)

Report
Copy link

Link copied!
Hello @JH-21011352-0,

The form isn’t uniquely identifying the row to update.

Your form’s Item property needs to match both Name and Attribute. Otherwise Power Apps updates the first record it finds for that Attribute.

Item Property:

LookUp( ExcelTable, //ExcelTable - Replace with your table name Name = Gallery1.Selected.Name && Attribute = Gallery1.Selected.Attribute )

Once the form is bound to a unique record, the Revised Value will update the correct row every time.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No