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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (7,064)