cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted
Community Support
Community Support

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.
Highlighted

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.

 

Highlighted

Hi,

 

Any help on this would be highly appreciated.

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,821)