add new row to gallery

(0) Share

Report

Posted on by Rozpalacz

Hi,

I have gallery: items

with columns: number, description, qty

how can I add new row (when button presses) to this gallery with:

number=111

description=niceitem

qty=10

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (3)

Sort by

Verified answer

Edwin-Abdalian 641 on at

Like
a
(4)

Report
Copy link

Link copied!

you need to use the Patch function on the OnSelect of your button. The Patch function will actually add a row to your Data Source.

Patch('YourDataSourceName', Defaults('YourDataSourceName'), { number:111 , description: "niceitem" , qty:10})
--------------------------------------------------
Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!

Was this reply helpful? Yes No
Verified answer

v-monli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Pablo2 ,

If you are new to PowerApps and you are trying to manage records from SharePoint list, please try to start with creating an auto-generated app. Select Home > Start from data > Create > SharePoint(Phone Layout) > fill you SharePoint site URL, select the listed List name, PowerApps will automantically create an app for you. If this app, you will see that normally we use an edit form to edit an existing item or create a new item. Gallery is for showing all the records from data source.

But if you do not want to use Form control to add new items, and you want to add one directly with the data:

number=111

description=niceitem

qty=10

I assume that all these fields are text/number column. Then you can a button control and set its OnSelect property to the formula that @Pablo2 suggested.

Regards,

Mona

Was this reply helpful? Yes No
Verified answer

Rozpalacz 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks

Was this reply helpful? Yes No
Quality2 33 on at

Like
a
(0)

Report
Copy link

Link copied!

I have similar situation but my columns have dropdown. how I should patch in this case?

Was this reply helpful? Yes No
Jagadeesh21 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hii @Edwin-Abdalian my data source is a collection , its showing an error , when i use my collection as a data source , how can i resolve it ????

Was this reply helpful? Yes No