General Discussion

Hello,

has anybody used a Microsoft Dataverse Table as source and/or destination of a form? If so, how?

If it is not possible, is there any intention to add it to the current integrations?

Thanks a lot

#PowerAutomate

#Dataverse

Hey Alicia,

This is a fantastic question and I want to thank you for posting it. Our good friend @Calvin Hunter has also inquired recently about integrating with Dataverse. Calvin mentioned in a previous conversation with me that he has begun looking into moving the data from TC to SharePoint and then into Dataverse. Calvin, would you mind commenting on the solution you were working on?

In the meantime I'll run this by our Solutions Architect to see what he can come up with. Stay tuned! :)

Hello,

has anybody used a Microsoft Dataverse Table as source and/or destination of a form? If so, how?

If it is not possible, is there any intention to add it to the current integrations?

Thanks a lot

#PowerAutomate

#Dataverse

Hi Chris,

Thanks for the tag.

Alicia,

It is likely possible using the Dataverse web API and TrueContext HTTP data source and destinations, though I have not gone down that route for any deployed workflows yet. Azure permissions in a big SOX-compliant organization can be painful...

Reference docs are here: Use the Microsoft Dataverse Web API (Dataverse) - Power Apps | Microsoft Learn

Depending on your exact needs, it is also fairly easy to set up power automate flows to "mirror" a SharePoint list or library to a Dataverse table, which is what I have personally done in the past. This lets TrueContext interact directly with SharePoint using their out of the box data destinations and data sources (which work very well), and PowerAutomate handles the interaction with Dataverse.

You would need to set up the following flows:

1. A flow to create a row in your Dataverse table when an item/file is created in your SharePoint Library or List.
2. A flow to update a row in your Dataverse table when an item/file is updated in your SharePoint List.
3. A flow to delete a row in your Dataverse table when an item/file is deleted in your SharePoint List.

If you need two way mirroring (e.g. interactions on the table mirrored to SharePoint), you'd need another set of flows going the other direction as well. There are quite a few examples of this provided by popular power platform content creators if you search Youtube, etc.

The use cases for this are probably few, but in my case I use it to mirror multiple extremely large document libraries and lists into single Dataverse tables. The document libraries are part of a workflow that predates Dataverse, so it is not feasible to migrate to a pure Dataverse solution at this point. Mirroring into a Dataverse table allows me to use the data in power apps without the delegation limitations that SharePoint has.

Hey Alicia,

This is a fantastic question and I want to thank you for posting it. Our good friend @Calvin Hunter has also inquired recently about integrating with Dataverse. Calvin mentioned in a previous conversation with me that he has begun looking into moving the data from TC to SharePoint and then into Dataverse. Calvin, would you mind commenting on the solution you were working on?

In the meantime I'll run this by our Solutions Architect to see what he can come up with. Stay tuned! :)

Hello,

has anybody used a Microsoft Dataverse Table as source and/or destination of a form? If so, how?

If it is not possible, is there any intention to add it to the current integrations?

Thanks a lot

#PowerAutomate

#Dataverse

Hello,

has anybody used a Microsoft Dataverse Table as source and/or destination of a form? If so, how?

If it is not possible, is there any intention to add it to the current integrations?

Thanks a lot

#PowerAutomate

#Dataverse