In this post, we’ll take a look at how you can get the details of user who has created/added, modified, or deleted a record in Dataverse. For example, perhaps you have a Power App where users can submit data, such as for requesting items, booking an appointment, submitting a form or making a check in. As they submit data, you want to use details such as the creator’s email address, name, address, job title, etc. in your flow.

The flow below will demonstrate the following:

  • There is a Power App connected to the Dataverse table called Appointments. Users create new appointments using this app, in turn creating a new Dataverse row/record in the table.
  • You will like to send a Teams message to someone with details (email address, full name, city and phone number) about who created the appointment.

Your flow will begin with the Dataverse action When a row is added, modified or deleted. Connect it to your Dataverse table (Appointments). In this example, the change type is only set as Added. Set the scope as Organization so that the flow runs based on anyone in the organization creating an appointment.

Screenshot of Power Automate Dataverse action: When a row is added, modified or deleted

For your next step, add in the Dataverse action Get a row by ID. Here, connect the Users Dataverse table. For the Row ID, add in the Dataverse dynamic content Created By (Value). This is the action that will give you further details about the user who created the appointment.

Screenshot of Power Automate Dataverse action: Get a row by ID

In your subsequent steps, you can now use information about the user such as that shown below as dynamic content.

Screenshot of Power Automate: Dataverse dynamic content from Users table

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s