Workflow failure with Dataverse only with PowerAutomate

(0) Share

Report

Posted on by Pherix

Hello all,

To setup some back story:
• I am only using the Microsoft Dataverse to hold information in the table. (No SharePoint)

• The Column that I am looking to trigger the workflow is named, "Progress".

• Once an item has a status of "Completed" within the "Progress" column, I would like it to send an E-Mail.

The workflow that I have setup so far is this:

Workflow - 1of2.png Workflow - 2of2.png

Ultimately, I am going to want to have a list that users can update and then the app will put that into the "To" section (much like I expect the "JIRA #" to function within the subject line), but for now, I am just trying to get it to send the E-mail to me.

I have sent E-Mails successfully from within this app (separate testing) and that seems to work fine, so I believe that I have everything setup correctly for the E-Mail mechanism to work, so I am thinking there is something wrong with my workflow. One restriction that I am working with is that I can only develop this application from within the Microsoft Teams "Power Apps" application. (I have also attempted to import this project using the .Zip file, but I do not have permissions to do so.)

Getting the automation working for the E-Mail notification would be a huge help to my company, so any help would be appreciated, especially with the given parameters - specifically that I am having to do this from within Microsoft Teams.

Thanks in advance guys. Any information would be helpful, even if its only WHY I cannot seem to get it to work, if not a solution.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Pherix

I see there are two triggers in your flow.

Power Apps and when a row is added, modified or deleted.

Want to know what are you using power apps trigger for.

Some modifications.

You should change your trigger from power apps to when an item is created, modified or deleted.

In the trigger settings of it you will have to change the trigger settings to, when progress column value is changed.

After this the flow should remain same.

Just one more change, instead of send an email notification V3, I would suggest you to use Office 365 outlook connector's action send an email(v2).

This is because of some limitations and how the v3 action has performed in last few months.

V3 has a limitation to only send 100 emails per day.

But with v2 you can send 900 emails every 60 seconds.

Plus v3 action has stopped like 5 times in the last year and many people have complained about it.

I hope this helps 🙂

Was this reply helpful? Yes No
Pherix 2 on at

Like (0)

Report
@Sundeep_Malik - Thanks for the response. To respond to your questions directly -

• Want to know what are you using power apps trigger for. -
Not sure what you are asking for here, as when I create a workflow, this is put in by default. When using the "Peek Code", I get the following:
{ "kind": "PowerApp", "inputs": { "schema": { "type": "object", "properties": {}, "required": [] } }, "metadata": { "operationMetadataId": "7b03cb44-3703-46cc-bd32-b3251c3b00e5" } }

I have also changed to the Office 365 outlook connector's action send an email(v2), as you have suggested, but the workflow is still not sending the E-Mail. (Tested this individually outside of a workflow, and it was successful, so I believe that the workflow is just not being triggered.)

Thank you.

Was this reply helpful? Yes No