
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.
Here is the table I entered:
I know its the correct table because the following steps displays fields from the custom entity
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.