RFC 3339 Error

(0) Share

Report

Posted on by kona134

Hi,

I am running into a RFC 3339 error in my app. The full error message is:

I am using Excel as a data source (which is bad and we're moving to SharePoint in the future). The app performs a LookUp from the data entered into the app and searches for a unique ID match in the Excel spreadsheet. If a match is found, it updates the record; if not, it creates a new one. I messed with the datasource (which is the cause) for readability reasons. The problem is that now the LookUp isn't writing/upserting records as intended to the data source. I've tried refreshing the data source in the app, creating a new table, deleting, etc. I've verified that the records with the unique ID posted to the data source exactly match the one(s) in the collection. The formulas still write to the source but it only creates, it doesn't update.

The error(found live monitoring) occurs in the OnSelect of a Submit button with the code:

ForAll(Filter(collection1, collection1[@Helper] in Table14[@Helper]),Patch(collection1,ThisRecord,{Revised:"Yes"}));Navigate('Submit Screen')

I've tried DateTime and DateTimeValue to try and see if that works- my initial thought that it was the 'Date Received' date picker causing the error but it throws out errors in the Patch(collection). So my next thought is that it must be that datasource. I've also tried changing the Date column to ISO 8601 manually in the Excel data source, but it throws the same error.

Any help is appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,779 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @kona134,

You are correct that Excel is a far from ideal data source - try using whatever unique identification field is in your Table
ForAll( Filter( collection1 As _col, _col.Helper in Table14.Helper ) As _Data, Patch( collection1, LookUp( collection1, YourIDField = _Data.YourIDField ), {Revised:"Yes"} ) ); Navigate('Submit Screen')

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 153,779 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No