Solved: Invalid Template when property is actually availab...

Tbruns · ‎08-09-2019

I am receiving the error message below when the property is available. Column name is "Date" and in the URL it shows "Field=Date1". I have tried entering Date and Date1 and neither is working. This Flow has been working for 5 months with no issues but now it is giving me an error. Nothing has been changed on the Sharepoint site. Please help as we rely on this flow everyday. Thank you!

Tbruns · ‎08-09-2019

I figured it out! There was a document that was loaded but they did not put in a date in the date field so it was returning "null". So make sure all your documents have something in the columns if this happens to you!

View solution in original post

Pstork1 · ‎08-09-2019

Does the Flow contain a Get items action at some point or does the Trigger use a View? If so could the existing View in SharePoint have changed in such a way that the Date1 column is still in the list but no longer included in the View that supports the Trigger or get items?

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Tbruns · ‎08-09-2019

The trigger is Get files. Not using Views

Tbruns · ‎08-09-2019

I figured it out! There was a document that was loaded but they did not put in a date in the date field so it was returning "null". So make sure all your documents have something in the columns if this happens to you!

Pstork1 · ‎08-09-2019

Yep, null column values will often throw strange error messages. Glad you figured it out.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.