cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Orvyn
Helper I
Helper I

Patching only selected columns to a SQL Data source

Hi there, 

I need to create an app working "offline". This works fine by making use of collections. However, I need to link two collections but I dont have a primary key yet, this gets created in SQL. I'm adding a column to a collection simply but (collect) and using GUID() as a temp primary key so I can link the two collections. 

I now have a challenge when trying to patch to the SQL table Patch(SQLTABLE, collection), due to the additional collumn. I there a wayt to patch only selected columns from the collection or drop die "GUID" column? 

Or should I try something else? 

 

Kind Regards

2 ACCEPTED SOLUTIONS

Accepted Solutions
Nogueira1306
Super User
Super User

Hey! Of course

 

Use a filter or a lookup
ForAll(

Patch(Filter(colection; Selected = true),

Defaults(SQL),

{

...

}

)

)

 

Something like that

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

View solution in original post

Ah thanks so much @Nogueira1306 for you help. This works perfect😀

View solution in original post

2 REPLIES 2
Nogueira1306
Super User
Super User

Hey! Of course

 

Use a filter or a lookup
ForAll(

Patch(Filter(colection; Selected = true),

Defaults(SQL),

{

...

}

)

)

 

Something like that

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

Ah thanks so much @Nogueira1306 for you help. This works perfect😀

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,302)