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
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 192 members 5,554 guests
Please welcome our newest community members: