OMFG HOW I HATE FLOW / POWER AUTOMATE!!!!!!

I am angry.

Very angry.

I hate everyone involved in the creation of this tool.  Even if you are trying to make it better.

I just want you all to get space herpes.

Today's rant is brought to you by an entire team of people who suck at their jobs.  Or...perhaps some people who are being told to not make things easier for people working with SharePoint data and to focus on making it super-easy to use the CDS/Dataflex Pro data store...

For the second time I have absolutely WASTED an hour of my time getting angrier and angrier as I roll back complex equations to something more simple over and over and over and just get terrible messages back from the platform.

I am forced to (time and again) break my code on purpose just to see how the error changes so I can see what the error ISN'T.  I have to copy pieces of code into lesser applications to bypass complex if/then structures.  I have to submit tests over and over while I just want to punch the lesser of my two identical monitors (you know who you are) and throw it out of my cube.

Today's adventure was:  Filtering a SharePoint list by Date.  Show me everything older than 7 days old.  That's it.

And nothing crazy here like using integer values counting seconds since date X.  I'm just filtering by the GODAAMMERUNG default Created field that is included in every single SharePoint list!!!!

Because of the worthless error message, I ran down multiple rabbit holes of trying to figure out if I needed to match time zones.  Then formats.  Then purposefully broke field names to figure out what in the world was wrong.  Then moved calculations out into variables just to prove I wasn't nuts.  Had multiple times where I tested and had the same error appear only to realize that I hadn't hit UPDATE on the "Expressions" tab before I hit Save.

"Oh, you want to change an Expression?  Well, you definitely have to hit UPDATE before we know you're seriously wanting to change an Expression.  Save definitely won't save what you've just done.  So you really need to hit UPDATE so we know you're serious.  Oh...and then hit Save.  Duuuuhr!"

Do you know what it was?

DO YOU KNOW WHAT IT WAS?!!!!?!!!

I left out the 'single quotes' around the date in my comparison.

That's it.

So I had:

Created lt @{addDays(utcNow(),-7)} <---WRONG!!! MORON!!!

When I should have had:

Created lt '@{addDays(utcNow(),-7)}'

Do this wrong and you will get a similar error:

{

"status": 400,

"message": "The expression \"Created lt 2019-12-02T17:44:42.4586847Z\" is not valid....(bunch of other stuff)"

}

And all it takes to fix this is to put the single quotes around the date function (as above) and it works.

Another One: Testing manual integer inputs

God help you if you have a Flow you want to test and decide to manually enter the values.  At least if one of those values is an Integer.  You'll get something similar to this:

The inputs by default for ANYTHING you type into a variable input field are all string.  Even though it knows you're putting in an Integer, it says "Hey!  I don't know what to do w/ this String here buddy!".  Because it always...ALWAYS...puts quotes around whatever you put in as a favor for you.

Final Thoughts

I did this exact same thing about a year ago and also got equally as mad.  How can this team be this bad w/ recognizing a problem that is so obvious to fix and that comes with every single SharePoint list by default?

And don't get me started on the fact that they have a "Limit columns by View" in the Advanced section of the SharePoint Get Items step that doesn't actually apply any filters in the View (that would be too obvious) but only filters WHICH COLUMNS and nothing else.  I mean...I get that you explicitly have it stated to say "limit columns".  However, anybody would assume that if I'm looking at a View vs. a full list, then I'd want ALL THE PARAMETERS OF THE VIEW APPLIED.

OMFG DO I HATE YOU PEOPLE!!!!!

And now I'm going to go back to making all of this work the way it should have 2 hours ago.