Editable grid in powerapps - patch errors

(0) Share

Report

Posted on by jamesmdc1

110

Patching error on "ID = ThisRecord.ID" with the error

"error when trying to retrieve data from the network. Fetching items failed. Possible invalid string in filter query. "

If(
 varGridEdit,
 If(
 !IsBlank(
 LookUp(
 colGridData,
 PURPART = Blank() || PURPART = ""
 )
 ),
 Notify(
 "Please Fill Required Fields",
 NotificationType.Error,
 2000
 ),
 // Update records in QUOTES2test using values from colSelected
 ForAll(
 colSelected,
 Patch(
 QUOTES2test,
 LookUp(
 QUOTES2test,
 ID = ThisRecord.ID
 ),
 ThisRecord
 )
 );
 Remove(
 QUOTES2test,
 colDelete
 );
 Clear(colDelete);
 Notify(
 "Grid Data Update",
 NotificationType.Success,
 2000
 );
 Select(btnloaddata);
 Set(
 varGridEdit,
 !varGridEdit
 )
 ),
 Set(
 varGridEdit,
 !varGridEdit
 )
);
Refresh(QUOTES2test);

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

jamesmdc1 110 on at

Like
a
(0)

Report
Copy link

Link copied!
Also tried patching like this which "does not" error, but also does not update the records in SP

If( varGridEdit, If( !IsBlank( LookUp( colGridData, PURPART = Blank() || PURPART = "" ) ), Notify( "Please Fill Required Fields", NotificationType.Error, 2000 ), ForAll( colSelected, Patch( QUOTES2test, LookUp( QUOTES2test, ID = Value(ThisRecord.ID) ), { TITLE: ThisRecord.TITLE, PURPART: ThisRecord.PURPART, QUOTENAME: ThisRecord.QUOTENAME, EC: ThisRecord.EC, ANNUSAGE: ThisRecord.ANNUSAGE, PURQTY: ThisRecord.PURQTY, SELLQTY: ThisRecord.SELLQTY, PURROUGH: ThisRecord.PURROUGH, LEADTIME: ThisRecord.LEADTIME, FOB: ThisRecord.FOB, CONTAINER: ThisRecord.CONTAINER, ROUGHWEIGH: ThisRecord.ROUGHWEIGH, ROUGHPRICE: ThisRecord.ROUGHPRICE, LINESC: ThisRecord.LINESC, PAINT: ThisRecord.PAINT, HEATTREAT: ThisRecord.HEATTREAT, QUOTENUMBE: ThisRecord.QUOTENUMBE, QUOTEDATE: ThisRecord.QUOTEDATE, SUPPLERNUM: ThisRecord.SUPPLERNUM, ACTMACH: ThisRecord.ACTMACH, SUHOUR: ThisRecord.SUHOUR, SETUP: ThisRecord.SETUP, SCRAPCOST: ThisRecord.SCRAPCOST, PROFIT: ThisRecord.PROFIT, FREIGHT: ThisRecord.FREIGHT, MATMARKUP: ThisRecord.MATMARKUP, TOTMACHINE: ThisRecord.TOTMACHINE, TOTALSELL: ThisRecord.TOTALSELL, QUOTESALE: ThisRecord.QUOTESALE, ANNUALMACH: ThisRecord.ANNUALMACH, ANNUALMAT: ThisRecord.ANNUALMAT, MACHMATPER: ThisRecord.MACHMATPER, ALUMMETAL: ThisRecord.ALUMMETAL, ADJUST: ThisRecord.ADJUST, TOOLING: ThisRecord.TOOLING, MACHDESC1: ThisRecord.MACHDESC1, MACHDESC2: ThisRecord.MACHDESC2, PATT: ThisRecord.PATT, DESC1: ThisRecord.DESC1, DESC2: ThisRecord.DESC2, ENGNOTES: ThisRecord.ENGNOTES, FOLLOWUP: ThisRecord.FOLLOWUP } ) ); Remove( QUOTES2test, colDelete ); Clear(colDelete); Notify( "Grid Data Update", NotificationType.Success, 2000 ); Select(btnloaddata); Set( varGridEdit, !varGridEdit ) ), Set( varGridEdit, !varGridEdit ) ); Refresh(QUOTES2test);
Verified answer

jamesmdc1 110 on at

Like
a
(0)

Report
Copy link

Link copied!
Also tried patching like this which "does not" error, but also does not update the records in SP
If( varGridEdit, If( !IsBlank( LookUp( colGridData, PURPART = Blank() || PURPART = "" ) ), Notify( "Please Fill Required Fields", NotificationType.Error, 2000 ), ForAll( colSelected, Patch( QUOTES2test, LookUp( QUOTES2test, ID = Text(ThisRecord.ID) ), { TITLE: ThisRecord.TITLE, PURPART: ThisRecord.PURPART, QUOTENAME: ThisRecord.QUOTENAME, EC: ThisRecord.EC, ANNUSAGE: ThisRecord.ANNUSAGE, PURQTY: ThisRecord.PURQTY, SELLQTY: ThisRecord.SELLQTY, PURROUGH: ThisRecord.PURROUGH, LEADTIME: ThisRecord.LEADTIME, FOB: ThisRecord.FOB, CONTAINER: ThisRecord.CONTAINER, ROUGHWEIGH: ThisRecord.ROUGHWEIGH, ROUGHPRICE: ThisRecord.ROUGHPRICE, LINESC: ThisRecord.LINESC, PAINT: ThisRecord.PAINT, HEATTREAT: ThisRecord.HEATTREAT, QUOTENUMBE: ThisRecord.QUOTENUMBE, QUOTEDATE: ThisRecord.QUOTEDATE, SUPPLERNUM: ThisRecord.SUPPLERNUM, ACTMACH: ThisRecord.ACTMACH, SUHOUR: ThisRecord.SUHOUR, SETUP: ThisRecord.SETUP, SCRAPCOST: ThisRecord.SCRAPCOST, PROFIT: ThisRecord.PROFIT, FREIGHT: ThisRecord.FREIGHT, MATMARKUP: ThisRecord.MATMARKUP, TOTMACHINE: ThisRecord.TOTMACHINE, TOTALSELL: ThisRecord.TOTALSELL, QUOTESALE: ThisRecord.QUOTESALE, ANNUALMACH: ThisRecord.ANNUALMACH, ANNUALMAT: ThisRecord.ANNUALMAT, MACHMATPER: ThisRecord.MACHMATPER, ALUMMETAL: ThisRecord.ALUMMETAL, ADJUST: ThisRecord.ADJUST, TOOLING: ThisRecord.TOOLING, MACHDESC1: ThisRecord.MACHDESC1, MACHDESC2: ThisRecord.MACHDESC2, PATT: ThisRecord.PATT, DESC1: ThisRecord.DESC1, DESC2: ThisRecord.DESC2, ENGNOTES: ThisRecord.ENGNOTES, FOLLOWUP: ThisRecord.FOLLOWUP } ) ); Remove( QUOTES2test, colDelete ); Clear(colDelete); Notify( "Grid Data Update", NotificationType.Success, 2000 ); Select(btnloaddata); Set( varGridEdit, !varGridEdit ) ), Set( varGridEdit, !varGridEdit ) ); Refresh(QUOTES2test);