cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GavinF69
Helper II
Helper II

ISO 8601 Errors on same form using same flow one set of data passes the next set of data flow fails???

Hi Community, yip I'm back again. This time with the strangest of errors... Form data being passed to SharePoint word template and new file being created and stored in a different SharePoint document folder. Submit the first captured/selected data in the form flow run is successful and document created as expected. Go and start capturing and selecting a second input 20 minutes apart and the flow fails with...

GavinF69_1-1669220797794.jpeg

Error details are really cryptic, since I didn't change anything between flow runs

 

GavinF69_0-1669220720457.png

 

At first I thought it might be related to a date field within the flow and went about defining and manipulating the date in the flow (even checking the value being passed prior to manipulation and checking it again after manipulation)...

GavinF69_2-1669221115594.png

Output of the above in the successful run shows:

GavinF69_3-1669221172676.png

I thought that maybe the SharePoint online column which is part of a content type didn't like the format as the column was defined as a Date/Time column, so I changed the column type to Single line text as there is no processing required on the date other than to put it in the newly create word document... seems to have made no difference, as the 1st run does as expected and in SharePoint I can see the formatted date

GavinF69_5-1669221429387.png

Value from 1st run in SharePoint

GavinF69_4-1669221386597.png

The second run through the flow fails in the set variable and then subsequent format compose action as follows (with the error messages at the top of this post)...

GavinF69_6-1669221659490.png

My attempt to catch the data state prior to updating the template file also doesn't help...

GavinF69_7-1669221809815.png

when I click download the inputs

GavinF69_8-1669221919423.png

 

and the outputs I see what I would expect to see

GavinF69_9-1669221973323.png

and then the subsequent update of the template file properties failure...

GavinF69_10-1669222051947.png

It can't be me surely? I think Flow and SharePoint are messing with me? Maybe someone out there in the universe has hit this snag before and point me to where this is going wrong.  There is only one other date used in the entire flow and that is to ensure that the output file has a unique name, so I define it with a Date/Time stamp which is only used in the name of the file and not in any SharePoint data column... Those statements and output below...

GavinF69_11-1669222439520.png

GavinF69_12-1669222474353.png

GavinF69_14-1669222624682.png

GavinF69_17-1669222835710.png

but on the second run... a failure in the compose timestamp action

GavinF69_15-1669222678007.png

yet the file name is created as expected????

GavinF69_16-1669222749783.png

Any help or guidance appreciated because this just blows my mind....

 

 

 

 

 

 

 

 

 

 

1 REPLY 1
GavinF69
Helper II
Helper II

So I can't seem to get around this issue, so I went and changed the output field in SharePoint to a single line text field, then changed the form input field to a single line text field, changed the SharePoint content type that it reflects single line text, changed the power automate flow to remove any reference to a date field and removed any date manipulation routines saved the flow and cleared all historic data from the form and captured new data. How is it possible that power automate still thinks there is a date value in the flow???? I'm still getting a stupid ISO 8601 error for something that does not exist anymore, is there some cache setting in flow that I don't know about? 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,187)