7 thoughts on “Azure Data Factory – If Condition activity

  1. Saul Cruz August 22, 2018 / 8:42 pm

    Great post, quick question though… don’t you need to CAST the Lookup and Get Metadata values to either Date or Integer and then compare?

  2. Saul Cruz August 23, 2018 / 3:16 am

    it’s funny but the way I solved this is by adding this to the lookup parameter.

    formatDateTime(activity(‘Get Last Load Date’).output.firstRow.ExecutionDate, ‘yyyy-MM-ddTHH:mm:ssZ’)

    I documented this question here https://github.com/MicrosoftDocs/azure-docs/issues/13838

    thanks for the post again

    • Mitchell Pearson August 25, 2018 / 10:45 pm

      Hey Saul! Thanks for the feedback and the link. The example that I shared in this blog post works without having to change any data types. I am really curious why your example doesn’t work and would like to recreate the problem on my end. I sent you an email with details, thanks again!

  3. Rayis Imayev (@RayisImayev) September 21, 2018 / 8:33 pm

    Hi Mitchel, I think you wanted to post the wait_FALSE activity screenshot the second time when you duplicated the True activity with wait_TRUE event. Thanks your blog post, it’s great!

    • Mitchell Pearson September 24, 2018 / 2:34 am

      Thanks Rayis for reading my blog, you’re 100% correct! I will do my best to update the blog this week. Thanks again for pointing this out 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s