Dynamics Online Task List coming due - Email

[JeffASnet]

Hello all and thanks in advance!

I am trying to create a flow that will run every day in the morning.  The intention is:

Get a list of Dynamics online tasks with a due date = today

Send a single email with a list of those tasks including basic pertinent info:

Task name

Description

Regarding

    (Regarding contact info: Email, primary number IF possible)

If someone could help with the syntax/expressions/etc I would be very grateful.  Still relatively new to flow.  I started with:    

Recurrance (Every 1 Day 8am)

Data Operation - Compose (formatDateTime(utcNow(),'MM/dd/YYYY')"}]})

Dynamics - List Records ("orgname", Tasks, Filter: statecode = 'Open')

Add a condition - This automatically became 'Apply to Each'

And thats where I got lost, because that seems to suggest an individual email per item, which I definately do not want.

[v-bacao-msft · Accepted solution]

Hi @JeffASnet,

You mean that after using Apply_to_each, Flow will send you an email when it detects that a task is eligible, but you want to receive only one email every day.

All you have to do now is to include the information of the eligible task in this email.

Maybe you could add a addtional condition in the Filter query of the List Records action to filter the Tasks that match the time, so you could avoid using Apply_to_each. You no longer need to configure the Condition.

Then use the Compose-- Select action to get the basic pertinent info. Select the corresponding value populate from Dynamic content options. Store them in a table and send them as the body of the email.

Please take a try and let me know if you have any question.

Best Regards,

Barry

[JeffASnet]

Hi Barry, 

Thank you for the reply.  I am able to get the solution you offered to work if I eliminate the OData query.  The issue specifically seems to be around statecode.  I attempted the statecode filter in another test solution and I get the same on either.  I am using the exact syntax you show in your reply [statecode eq 'Open']

The tests fail at the Get List item with:

{
  "status": 400,
  "message": "A binary operator with incompatible types was detected. Found operand types 'Edm.Int32' and 'Edm.String' for operator kind 'Equal'.",
  "source": "avyachts.crm.dynamics.com",
  "errors": [],
  "debugInfo": "clientRequestId: c6d66b8b-4671-49ac-84ed-71dec64fb9b6"
}

I have attempted the filter using OData query with single, double, and no quotes and it fails each time.

Thanks,

[v-bacao-msft]

Hi @JeffASnet,

Could you share the configuration in your Filter query?

I am afraid that the previous post has caused you misunderstanding. My configuration in the Filter query is just an example.

The main thing is to configure it according to your own actual situation.

As for what you said [statecode eq 'Open'], I noticed that in your first post, the Condition set that section has this condition, so I added it.

Please make sure that the condition of the Filter query configuration is what actually exists in your Entity.

Best Regards,

Barry

[GabrielStJohn]

Hey, @JeffASnet!

Thank you for posting on the Flow Community Forum! It appears as though @v-bacao-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

[JeffASnet]

HI Barry, 

Thanks for keeping up on this.  We were able to figure out a more meaningful way to filter to what our client really needed, so the specific query I was troubled with is no longer an issue.  However, you initial response with the detailed explanation and images got me where I needed to be.  I have accepted it as the the answer to my question.  Thanks for the very helpful response to this Newbie 🙂