Share
Report
125Hi,
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!
All responses (
Answers (
