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

add new row to gallery

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.

3 ACCEPTED SOLUTIONS

Accepted Solutions
Edwin-Abdalian
Solution Supplier
Solution Supplier

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!

View solution in original post

v-monli-msft
Community Support
Community Support

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

 

 

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Pablo2
Helper I
Helper I

4 REPLIES 4
Edwin-Abdalian
Solution Supplier
Solution Supplier

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!

View solution in original post

v-monli-msft
Community Support
Community Support

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

 

 

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Pablo2
Helper I
Helper I

Quality2
Regular Visitor

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

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,668)