
Announcements
Hey,
I'm currently experimenting with using dataverse as database for a monthly reports made by power automate workflow. Is it possible to make power automate workflow which creates a new table into dataverse and populates it with data from previously made excel sheet? Would be ideal to have everything automated straight away.
Thanks!
Riku Nieminen
Why can't you pre-create a table with a schema of your choice and then use power automate to populate the data?? if you've a requirement of a dynamic table where your columns are variable, I'll recommend to use elastic tables in Dataverse which use a Cosmos DB in the backend.
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/elastic-tables