Add record in the Gallery Table

[anubhavkapoor]

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?

[v-yutliu-msft]

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

[anubhavkapoor]

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]

Hi,

Any help on this would be highly appreciated.

[Drrickryp]

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