use sql quey result (date) in a condition

[Vbv]

Dear all,

I execute a sql query with the following outcome:

{

"OutputParameters": {},

"ResultSets": {

"Table1": [

{

"Date": "2019-07-13T00:00:00"

}

]

}

}

I would like to use the field [Date] outcome to check whether its equal to today's date (utcnow('yyyy-MM-dd'). However my outcome is false. I cant use the formatdatetime on the sql query because its an item and not a string.

Any advice on how to build it?

In the end, my goal is to check in the datetable whether the workday of the month is between 5 and 9 and it must be a wednesday, then the daily scheduled flow will return a true. any advice on how do to this differently is welcome as well!

best

[v-bacao-msft · Accepted solution]

Hi @Vbv ,

Could you share a screenshot of the Flow configuration?

Please consider using Parse JSON to parse outcome, and then use Condition to determine if Date is equal to today's date when traversing Table1.

You could refer to the following blog to understand the usage of Parse JSON:

a-thesis-on-the-parse-json-action-in-microsoft-flow

https://flow.microsoft.com/en-us/blog/five-services-json-http/

The Expression you might use should be:

formatDateTime(item()['Date'],'yyyy-MM-dd')

Best Regards,