Answered

Help Needed: Power Automate Flow to Notify for Dataverse Table Structure Changes

(0) Share

Report

Posted on by Siva_Kumar_M

Hi everyone,

I'm working on setting up a Power Automate flow to monitor and notify about any changes in the structure of any Dataverse tables within an environment. Specifically, I need the flow to detect changes such as:

Addition of new columns
Deletion of columns
Changes in data types of existing columns
Renaming of columns

Any guidance, examples, or resources on setting up this flow effectively would be greatly appreciated. Thank you in advance for your help!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Jonathan Manrique 2,687 on at

Like (0)

Report
Copy link

Link copied!

Hi @Siva_Kumar_M

Through Power Automate you cannot achieve this with existing connectors. The dataverse connector is against tables and data, but not against the structure. What you are asking for is a Power Apps GIT at the table level, and I have not seen that until today

You would have to see if you can achieve this functionality with the SDK.

Was this reply helpful? Yes No
Gabriel Dias Junckes 69 on at

Like (0)

Report
Copy link

Link copied!

It seems you are looking for versioning control of the environment.

Is this environment managed? If you could look at this in the source control and compare it with a Pull Request?

If you decided to use the Power Automate to retrieve the metadata you would still need to save a snapshot somewhere to be able to compete it later.

Was this reply helpful? Yes No
Siva_Kumar_M 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the suggestion @Jmanriquerios and @gabrieljunckes.
@Jmanriquerios What's your thoughts on the possibility of achieving this requirement.

Was this reply helpful? Yes No
Verified answer

Jonathan Manrique 2,687 on at

Like (0)

Report
Copy link

Link copied!

Hi @Siva_Kumar_M

With Power Automate very complicated, because when you delete a table how do you get that information, you would have to create a version. In the end you are looking for a version manager and until today I do not know it at the dataverse level, different for web resources, plugins that are introduced within a solution that you can use a version manager.

Was this reply helpful? Yes No
westerdaled 649 on at

Like (0)

Report
Copy link

Link copied!
I have a similar requirement to this but in the context of a solution deployed to another environment via Power Platform Pipelines

Tables added or removed since the previous release
Are those tables included in the custom security role , included in the solution
Again column changes such type changes and others mentioned above
Is the only option to run post deployment checks: use GitHub actions via a power automate to unpack the (unmanaged) solution.zip and somehow interrogate the various entity.xml files and, or role files (my basic user. xml) . Note we use Azure DevOps to manage our repos.
With some column structure changes, such as column type changes you need a early warning to compare table columns in source and target environments, as some changes seems to break the deployment.

Was this reply helpful? Yes No