web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Power apps query

Power Apps

Answered

Power apps query

(0) Share

Report

Report

Posted on by Dupreti

Hi Experts,

Need your immediate help. I am working on editable grid power apps like excel but when I am editing the grid and then exit the grid it is creating multiple items/ records.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Dupreti ,

Could you please provide some screenshots of your App and formulas? That will make it much easier to assist.
I have made a test for your reference.

Here is my SharePoint List.
1. Add a Gallery Control and modify its template, I used some 'TextInput' Control to replace the 'Lable' Control.
2. Select the TextInput Control and apply the following formula on its Default property as:
ThisItem.ColumnName
3. Select the TextInput Control and apply the following formula on its OnChange property as:
Patch(datasource,ThisItem,{ColumnName:TextInput1.Text})
4. Add a Icon and apply the following formula on its Onselect property as: (Create an empty record)
Patch(datasource,Defaults(datasource),{})
5. Add a Icon and apply the following formula on its Onselect property as: (Delete current record)
Remove(datasource,ThisItem)
Result:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No

Join the conversation