cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anubhavkapoor
Level: Powered On

Add record in the Gallery Table

Hi All,

I was going through the PowerApps docs. Is there any command to add record to datasource like 'Remove'.?

 

Note: Can i use Patch function with Defaults to add a record to datasource but how will I create a dynamic row in table on click of 'Add Record' button?

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Add record in the Gallery Table

Hi @anubhavkapoor ,

Do you want to konw how to create a record in PowerApps?

I suggest you try Patch and Collect function.

1)Patch:

Patch(tablename,Defaults(tablename),{field1:...,field2:...,fied3:....})

2)Collect:

Collect(tablename,{field1:...,field2:...,fied3:....})

If you use an edit form to update record, you could also try submitform funtcion.

The synax is: SubmitForm(Form1)

Could you describe more clearly about "a dynamic row"?

Do you want to modify record?

Here's some docs about creating and modifying records for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearc...

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-form

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
anubhavkapoor
Level: Powered On

Re: Add record in the Gallery Table

Hi,

Thanks for your message. Patch function with Defaults did the trick.

 

However one thing which is hampering User Experience is: I have achieved this functionality of 'Addition' by creating another screen and using Patch functionality.

 

I want to add the record on the same scren by using a pop-up ( on click of + icon) OR by making another row visible on click of + icon.

 

anubhavkapoor
Level: Powered On

Re: Add record in the Gallery Table

Hi,

 

Any help on this would be highly appreciated.

Super User
Super User

Re: Add record in the Gallery Table

Hi @anubhavkapoor 

It sounds alot like what Shane Young @Shanescows , did to simulate Infopath forms in Powerapps.  This is a solution where the data entry is done at the Gallery level.  Please check out his video.  There are two more that follow on this one and see if this meets your design requirements. 

 https://powerusers.microsoft.com/t5/Video-Gallery/Repeating-Tables-like-you-had-in-InfoPath/td-p/127...

 

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,139)