Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Power Apps - dataverse...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Power Apps - dataverse connection

(0) ShareShare
ReportReport
Posted on by Mark Wright 5

Hi all,

We have a third party booking system and currently when a booking comes in, the user inputs these details manually (archaic I know!). We are using Power Apps as our CRM system which I built, but I am aware that the information is stored within the dataverse.

The booking system is able to connect to Zapier to allow automation, and this would bring the information through to an Excel Workbook.

My questions is - is it possible to have an Excel Workbook in the dataverse, which with import the information from new bookings into the CRM which would then be stored in the dataverse?

Please excuse my limited understanding of this, as I really don't want to lose any information we already have, but at the same time am wanting to automate the simple process as soon as possible.

Any assistance would be much appreciated.

Many thanks and stay safe

Mark

  • Mark Wright Profile Picture
    Mark Wright 5 on at
    RE: Power Apps - dataverse connection

    Hi Matt,

    Thank you so much for the information.  Looking at everything, it might be a better route to go down the Zapier Dynamics 365 route.

    I am using the MS Power Apps and not Dynamics 365, but this does appear to connect successfully with Zapier.

    I would like to forewarn you here that I am NOT an expert! Everything I know about MS PowerApps, Web design and creation is from learning and not formal training, so may question may seem a little bizarre!!

    I have to use the API setting rather than an entry being put direct into a table, as Zapier searches for the default tables, and not all of my bespoke columns are listed. So, if I am going to use the API function, I presume it would be the PUT option for HTTP (I know that sounds a silly question!)? The URL would be my organisation dynamics address? The Query String Parameters would be the column Schema in my bespoke CRM, and which item the booking form would relate to it?

    Any help would be much appreciated.

    Many thanks

    Mark

  • Suggested answer
    Mattb-Motive Profile Picture
    Mattb-Motive 25 on at
    RE: Power Apps - dataverse connection

    Hi Mark

    Yes, it is possible.

    Last year Microsoft introduced a feature in Dataverse called Virtual Tables. This allows you to connect to other data sources and combine it with Dataverse and model-driven Power Apps.

    There are a number of steps to complete in order to set it up. More information can be found here: learn.microsoft.com/.../create-virtual-tables-using-connectors

    Known limitations and troubleshooting with virtual tables: learn.microsoft.com/.../limits-tshoot-virtual-tables

    A couple of alternative solutions:

    • Create a Power Automate flow when a new row is added to an Excel file, you could then create a new record in your relevant Dataverse table.
    • Investigate if the Zapier Dynamics 365 action can directly create a row in the relevant table instead of Excel.

    Good luck with it.

    Thanks

    Matt

    Motive Consulting | LinkedIn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans