Power Platform Community Forum Thread Details

Hi,

Is it possible to set the trigger condition for the Dataverse trigger "When a new row is added, modified or deleted" based on the lookup fields of a Lookup column in Dataverse?

My understanding is that you can use the GUID of the Lookup to assign a trigger condition. Despite the upside of the GUID being immutable, I find that there are a couple of downsides (for me personally) including:

Difficult to ensure that the GUID will be maintained when migrated across environments (e.g. Dev/UAT/Prod)
Difficulty in deciphering what the GUID maps to if I was to revisit. It's not like a simple ID column in SharePoint.
Easy to make a mistake when copying a long GUID string to use as a reference or missing human error if it was accidentally edited

If it isn't possible, I may have to include an additional column in the table where the Lookup column resides that serves as a unique identifier back to the lookup table. This could be a simple ID column for example. I'm not a fan of this solution however, as it requires maintaining two columns that map back to the same table.

Any ideas would be appreciated - thank you!

Categories:

Building flows