cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KurtH1994
Helper I
Helper I

Editable Grid on Powerapps creating duplicates when patching a collection

Hi,

 

New to powerapps and not entirely sure what is happening with my app. I am patching data from a collection and for some reason when i click my "SAVE WIP" button it is creating a duplicate of my first row in the gallery from the colgriddata. Below is a copy of the code for the onselect function for my "SAVE WIP" button. Every time i click the button it keeps returning duplicates even though no data was edited.

 

recording.gif

 If(
varGridEdit,
If(
!IsBlank(
LookUp(
colGridData,
IsBlank(Title)
)
),
Notify(
"Please Enter Block Number",
NotificationType.Error,
2000
),
Patch(
'QSV WIP Monitor',
UpdateIf(
colGridData,
Created = Blank(),
{ID : Blank()}
)
);
Remove('QSV WIP Monitor',colDelete);
Notify(
"WIP Updated",
NotificationType.Success,
2000
);
Clear(colDelete);
Select(btnLoadData);
Set(
varGridEdit,
!varGridEdit
)
),
Set(
varGridEdit,
!varGridEdit
)
);

 

Thanks,

Kurt

12 REPLIES 12
MustH
Helper III
Helper III

@KurtH1994 Hi

 

Have you achieved what you wanted?

because I want to make exactly the same line item experience as yours...

havegoogday06
Microsoft
Microsoft

Hi MustH, 

I think the error was coming from the combox box. 

I followed this tutorial and now it's working. 

 

Gallery Inline Editing Power Apps - YouTube

Val

MustH
Helper III
Helper III

@havegoogday06 

I have seen this video, but I want to make an editable grid with like 25+ columns
having (Text Inputs) and ( Combo Boxes)

I watched Reza Video
https://www.youtube.com/watch?v=wI6SHGQ9ATg

But I am stuck I have to select twice to select a combo box or a text input ..

and I have few more issues can you help ? @StalinPonnusamy 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,308)