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

Patch (Defaults) SQL table collect


Insert a collection into an SQL table
Formula :
Patch('[dbo].[Matrix]';Defaults(Collect6))


- You must specify values ​​for the item. clientReguestid - error
Collect 6 - in collection6, all fields are filled except for the id1 (primary key) field (It should go automatically)

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User III
Super User III

ForAll(Collect6,

Patch(
'[dbo].[Matrix]',Defaults('[dbo].[Matrix]'),
{ColumnName1: CollectionColumnName1,
ColumnName2: CollectionColumnName2,
ColumnName3: CollectionColumnName3,
ColumnName4: CollectionColumnName4}))

 

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution

View solution in original post

2 REPLIES 2
eka24
Super User III
Super User III

ForAll(Collect6,

Patch(
'[dbo].[Matrix]',Defaults('[dbo].[Matrix]'),
{ColumnName1: CollectionColumnName1,
ColumnName2: CollectionColumnName2,
ColumnName3: CollectionColumnName3,
ColumnName4: CollectionColumnName4}))

 

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution

View solution in original post

Arsnova
Frequent Visitor

Thank you very much!!!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (75,003)