Dataverse: Create Custom API to retrieve data of requiredattendees/optionalattendees on Appointment table


The article discusses how to use the Appointment table in Power Automate and trigger an email to the RequiredAttendees/OptionalAttendees when the Appointment status is completed. The author provides code for creating a Custom API that retrieves data from the Appointment table based on specified parameters. The code retrieves the Attribute of the Target entity, retrieves the ActivityParty.PartyId from the EntityCollection, and sets the Result parameter. The author also demonstrates how to use the Custom API in a Power Automate flow to send emails to the attendees. The article includes code snippets and screenshots for reference.


Article 4m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time