I have a transaction table called Registration which has a lookup to a Events table. The event table has a choice column 'AutoSendEmail'. Now, whenever the 'Approval Status' column in the Registration table is updated, we would like to send an email out provided the corresponding event records AutoSendEmail = 'Yes'. How do I build the ODATA filter condition on the trigger in the Registration table to check the AutoSendEmail in the Events table.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.