cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tbruns
Post Patron
Post Patron

Invalid Template when property is actually available

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!

08-09-2019 10-02-21 AM.jpg08-09-2019 10-02-56 AM.jpg08-09-2019 10-04-17 AM.jpg08-09-2019 10-04-41 AM.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

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

4 REPLIES 4
Pstork1
Dual Super User
Dual Super User

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.

The trigger is Get files. Not using Views

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
Dual Super User
Dual Super User

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.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Top Solution Authors
Top Kudoed Authors
Users online (3,058)