Unanswered

Network error when using Patch function: Length must be between 0 and 100

(1) Share

Report

Posted on by SumoTechSimon

Whist trying a simple patch function in Apps I am getting this error. I am using a checkbox and the code for OnCheck is as follows:

Patch(DespatchLines_1, Defaults(DespatchLines_1), {Despatch_RMA:ThisItem.RMAAutoNo, Despatch_PN:ThisItem.Product, Despatch_PO:ThisItem.'PO#', Despatch_Serial:ThisItem.'Serial #',Despatch_Desc:ThisItem.'Product Description' ,DespatchL_RDN:Header.LastSubmit.Despatch_No})

The strange thing is that I am using an almost identical function in another app and that works fine.

Looking forward to your help.

Simon

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Federico_Oriani 60 on at

Like (2)

Report

Hello SumoTech,
The problem is that one of the fields within the Patch function has a maximum limit of 100 characters, and it seems that during field compilation, you have exceeded this limit.
Could you please try again, ensuring that each field has a maximum of 10 characters?

Just for test purpuse.

Best Regards,
Federico

Was this reply helpful? Yes No
KD-24070946-0 13 on at

Like (0)

Report

Hi Simon,

I get the same error sometimes when moving data from SharePoint lists into Dataverse tables.

I have found that adding the following function to set a variable immediately after the patch statement sometimes can show me the column which caused the issue, but it doesn't seem to be 100% reliable and sometimes shows nothing.

Concat(Errors(Bookings), Char(13) & Message & " (" & Column & ") " & Error)

It can be useful in pointing you in the right direction, especially if you have lots of columns in the Patch statement.

If this doesn't work I usually end up building two collections and checking the length of every column of incoming data which could be the cause.

Good luck!

Was this reply helpful? Yes No