Power Automate Flow Wont Trigger

(2) Share

Report

Posted on by nvrhughes

319

Hello,

I am trying to create a simple Power Automate flow that triggers when a field is added or deleted from a table.

The table is custom and I believe it is a lookup table being that all fields within it are lookups. I am able to query the table in XRM toolbox but cant seem to find the table when searching through our objects in make.powerapps.

I know there are issues with triggering flows on lookup fields, but wasnt sure about lookup tables. I tried turning my flow off and on, re-creating the flow, and even tried in a different test environment but the flow will not trigger.

After making the change within Dynamics, I'm able to run a query and see the new record in the DB.

Any help would be greatly appreciated. Thank you!

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi，

Doesn't this table appear here?

I am trying to create a simple Power Automate flow that triggers when a field is added or deleted from a table....I know there are issues with triggering flows on lookup fields,...
Do you want the flow to be triggered by a change in a lookup field on this custom table?

Or by an addition or deletion of a record in another table pointed to by a lookup field?

For example：

In my custom table(Case Product), there is one lookup: Product(cre80_product)， this lookup point to another table--Product.

My flow:

1）Changes to the value of this lookup field on this custom table

2）Addition or deletion of records from the table pointed to by this lookup field

Can you provide more details? It would be better if a screenshot of the problem is included.

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No
nvrhughes 319 on at

Like (0)

Report
Copy link

Link copied!

@Leah Ju

I only want to trigger the flow when a record is created or deleted in the custom table, not modified.

Here is my trigger. I started by hitting added or deleted then hit add custom value.

Here is the table I entered:

I know it found the table because the fields are displaying when populating the next step:

As far as the table, no it does not show in the custom table screenshot you provided below.

We treat the table as a "middle man" to relate it with opportunity records. Here is an example of one of our custom views using the table.

In red is the table im trying to use to trigger the flow. Avtex_avtex_floorplan_opportunity is a linked entity to opportunity. We then link this entity to avtex_floorplan so we can get the name of our floorplan. Avtex_avtex_floorplan_opportunity contains the floorplan ID and opportunity ID. Avtex_floorplan contains the front end name of the floorplan which is what we use in the view.

Was this reply helpful? Yes No
nvrhughes 319 on at

Like (0)

Report
Copy link

Link copied!

@Leah Ju Any update?

Was this reply helpful? Yes No
Verified answer

nvrhughes 319 on at

Like (0)

Report
Copy link

Link copied!

M:M relationships generate a table, yet it is not defined as a table in dataverse and can not be manually updated nor can it trigger a flow.

Was this reply helpful? Yes No