Power Platform Community Forum Thread Details

Hi,

I have a canvas app which patches everything into a Temporary sharepoint list, this list is used as a QAQC check. Another more experienced user looks at the data and ensures its integrity and values are correct.

Can i patch the Sharepoint List to the SQL database? or should i use a flow? what are the advantages of each for say a poor internet connection?

ForAll(
 TempSharepointList,
 Patch( 
 SQLDATATABLE,
 Defaults(SQLDATATABLE),
 {
 Date: Date,
 SpecialID: SpecialID,
 RandomTXT: RandomTXT,

Etc etc

Currently i have errors saying incompatible column types (all my values in SQL are nvarchar(50) because it doesnt matter what format for my purposes) - Error is does not match expected type text found type error?

If i can patch am i able to group the sharepoint list by a unique ID in a drop down? ie i only want to patch ZZ001 this time but next time i may want to patch ZZ001 and ZZ002 but not ZZ003 etc?

For example my data

Date	SpecialID	RandomText	RandomDropdown
1/1/2022	ZZ001	Loko1	698321RR
1/1/2022	ZZ001	Loko12223	ddff
1/1/2022	ZZ001	Loko12414	698321RR
1/2/2022	ZZ002	Loko1241	dsad
1/2/2022	ZZ002	Loko1	698321RR