All integrationsDatabases
Microsoft Dataverse
Dataverse is the database under Power Apps and Dynamics 365.
- actions
- 20
Actions
Steps a workflow can run in Microsoft Dataverse.
- Check connectionConfirm the connection works and return the application user's ID, its business unit and the organization ID.
- List tablesThe tables in the environment, with each one's logical name, entity set name, display name and primary key column. Search by name, or show only custom tables.
- List columnsA table's columns with their logical names, types, required level and whether each can be set on create or update.
- List choice optionsThe options of a choice, multi-select choice, status or status reason column: each option's number, which is what a row stores, and its label.
- List relationshipsA table's relationships and the navigation property names the other actions need: the relationship to associate or list related rows through, or the name to set a lookup with @odata.bind.
- List rowsRows from a table, filtered and sorted with OData, a page at a time. Pass next_link back to get the next page.
- Get rowOne row, by its ID or by an alternate key.
- Create rowAdd a row to a table and return it with its new ID.
- Update rowChange some columns of an existing row. Columns not given are left as they are. Fails rather than creating a row if the ID does not exist.
- Upsert rowUpdate a row found by ID or alternate key, or create it if it does not exist. Reports which happened.
- Delete rowPermanently delete a row.
- Clear column valueEmpty one column of a row. To clear a lookup, use Update row with <navigation property>@odata.bind set to nothing.
- Associate rowsLink a row to another through a one-to-many or many-to-many relationship, such as adding a contact to an account.
- Disassociate rowsRemove the link between two rows. Neither row is deleted.
- List related rowsThe rows linked to one row through a relationship, such as an account's contacts, a page at a time.
- Run FetchXML queryRun a FetchXML query, such as one downloaded from Advanced find. The table is read from its <entity name>. Empty columns are left out of each row.
- List viewsA table's active system views, with the default view's ID picked out for Run view.
- Run viewThe rows a saved system view shows, with its filter, columns and sort. Empty columns are left out of each row.
- Count rowsHow many rows match a filter, up to 5,000. limit_exceeded is true when there are more.
- Search rowsRelevance search across tables, like the search box in a Power Apps app. Needs Dataverse search turned on, which Developer and trial environments leave off: Power Platform admin center > Environments > your environment > Settings > Product > Features > Dataverse search.
No actions match that.
Automate Microsoft Dataverse with Lodol.
Connect Microsoft Dataverse, then hand Lodol the job in Slack, Claude or ChatGPT.
Free plan, no credit card