Automatically create a record in Dataverse when a new record is created in Dataverse for teams?

[Aivi]

Hi all

I am planning on providing a canvas app for external users, to let them enter data in MS Teams. 

When the external users create a new record, I wish to use Power Automate to automatically create a new record in a model-driven app for internal users. Is that possible?

I have already made a POC using SharePoint as a temporary data storage, but I would like to avoid this extra data-layer if possible.

I tried asking Chat GPT - and the reply was to use the "Dataverse for Teams (preview)" connector, but I see no documentation on that elsewhere... I am based in Europe (Denmark).

Any suggestions would be highly appreciated.

Kind Regards,

Malene

[ChrisPiasecki]

Hi @Aivi,

Model driven apps are not available in Dataverse for Teams.

I would suggest looking at Power Pages to allow external users to enter data into Dataverse. You can then build a model driven app for internal users to view the data and perform the business processes needed. Since the data is all in Dataverse, you don't need to worry about any duplication or synchronization of data in multiple places. This is one of the biggest advantages of Power Pages.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[Aivi]

Hi @ChrisPiasecki 

Thank you very much for taking your time to reply on this topic... I am not absolutely sure that this will be the right solution for me though, therefore I hope that you can find the time to get back to me on the following as well.

My goal is to let my "external" users (blue collar workers) report "issues" using MS Teams, since this will be the business platform available to this group of employees. They will all have an "onmicrosoft" account.

I can easily do this by publishing a canvas-app on top of the model-driven app, but I was hoping that I could avoid activating the license (pay-as-you-go) for this scenario, which is why I was considering using PowerApps for Teams and transfer the data from there. I already succeeded in doing this, but using SharePoint as a data source for the PowerApp and transfering the data to the full dataverse from there.

I am not very familiar with PowerPages yet, but as far as I know, I will need to activate a license for that as well, correct?

To begin with it will only be around 150-200 issue reports a year... but the plan is to make this count grow due to smooth user experience.

In that perspective - would you still recommend Power Pages over a PowerApps pay-as-you-go license? Or would you maybe consider the current "work around" with SharePoint sufficient, until I can use the "Microsoft for Teams" connector to fetch the incoming data?

Thank you again.

[ChrisPiasecki]

Hi @Aivi,

If it's a simple issue tracker with only a few hundred records per year, then using a SharePoint list as the single data source would be the easiest solution without requiring additional licensing. You can create the list inside of the Team site that the external users and internal users have access to make it easy. 

Unless there is some additional complex process the internal users need to manage the issues, I wouldn't bother with a model driven app.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up

[Aivi]

Hi @ChrisPieasecki,

That is not the case... this is just an add-on to a Model-driven app that is already in production for the internal business users.

I have decided to publish a canvas app in Teams, licensed by pay-as-you-go. This way there will be no extra development and the users will create the records directly in the "target" solution.

Thank you for taking the time to give your input on this.

Kind Regards. Malene

[AhmedSalih]

Hello, @Aivi, thank you so much for inspiring me to test your use case 😃 I was able to create a Dataverse for Team app, and I saved the data collected from the app to a temporary SharePoint List. Then I created a Power Automate Flow that will trigger every time there is a record created in the SP list. That flow will use the newly created SP record and create a record in the Dataverse table for Internal users to access. 

So to answer your Question: "When the external users create a new record, I wish to use Power Automate to automatically create a new record in a model-driven app for internal users. Is that possible?" 

Yes that is possible.

 

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

[Aivi]

Hi @AhmedSalih 

I apologize for my late reply and I am glad that my use case could work as inspiration. 🙂

Unfortunetely, the solution you describe is exactly what I had already done...

My worry about this approach, is that we end up having data in three different tables instead of only two. (result is more maintenance and risk of error) Therefore I was hoping to be able to do the same thing, but without the temporary SharePoint list.

I wish that "create new record" in Dataverse, should be triggered by a new record in "MS Dataverse for Teams" in stead of a new record in a SharePoint list.

It seems that a new connector "Dataverse for Teams (preview)" is coming for this purpose and in the meantime we have decided to use the "pay-as-you-go" licenses for the "native" app.

Kind Regards, Malene 🙂