web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / How can a let external...
Power Apps - Microsoft Dataverse
Answered

How can a let external people connect to dataverse?

(0) ShareShare
ReportReport
Posted on by naaatthh 22

I feel like I'm missing something obvious but I'm still very new to powerapps. I tried to make a custom API and I wanted to give people outside my organisation the ability to pull data from tables through it. But I can't figure out how. The solution has the tables and flows within it but it's still in testing phase so I haven't exported it or anything.

 

What do I need to give them to enable them to do this? 

 

Thanks in advance

Categories:
Microsoft Dataverse
Solution Explorer
I have the same question (0)
  • Mira Ghaly Profile Picture
    Mira Ghaly 11,413 Moderator on at
    Re: How can a let external people connect to dataverse?

    @naaatthh 

    By people outside your organisation do you mean third party integrators, and by custom API I think you mean a Rest API hosted on Azure is that correct?

     

  • naaatthh Profile Picture
    naaatthh 22 on at
    Re: How can a let external people connect to dataverse?

    @Mira_Ghaly I haven't done anything within Azure, I have just created a custom API inside of a solution. But the requirement is that the application they are developing needs to pull data from my Dataverse tables. I'm not sure if I've approached this the correct way. Any recommendation on the best approach for this would be appreciated!

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,413 Moderator on at
    Re: How can a let external people connect to dataverse?

    @naaatthh 

    Custom API can't be used for this purpose for external integrations but they can't be used to expose custom messages in dataverse, similar to custom actions.

    In case of external integrations you need a Rest API hosted on Azure

     

  • nathanmcowen Profile Picture
    nathanmcowen 5 on at
    Re: How can a let external people connect to dataverse?

    I

  • naaatthh Profile Picture
    naaatthh 22 on at
    Re: How can a let external people connect to dataverse?

    @Mira_Ghaly 

    I've managed to collect data from tables using Postman. Just to make sure I'm being fully clear about what I need, I've listed it below.

     

    1. A customer will log in to their account on a website.

    2. That website pulls data from Dataverse based on the customer's unique ID.

    3. The customer can then see that data on their homepage.

     

    It is purely read-only and the customer will have no direct control over data.

     

    Is there an alternative that would work besides Azure? 

  • mjburley Profile Picture
    mjburley 370 on at
    Re: How can a let external people connect to dataverse?

    This would normally be done using the Dataverse API.

     

    So all the coding would be done on the website, and it would use the API to bring any data across. This is normally used to avoid using DataVerse portals.

     

    So you don't need to do anything on your side except provide access for your Dataverse instance.

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,413 Moderator on at
    Re: How can a let external people connect to dataverse?

    @naaatthh 

    You mean using the dataverse API directly using post man.. and yes the customers can use it directly to access the tables and they will handle the authentication and everything on their side.

    This is a sample code using c#:

    https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/quick-start-console-app-csharp?tabs=adal

     

     

  • naaatthh Profile Picture
    naaatthh 22 on at
    Re: How can a let external people connect to dataverse?

    @mjburley Thank you! How do I find my Dataverse instance? Is that the <orgname>.api.crm4.dynamics.com?

  • Verified answer
    mjburley Profile Picture
    mjburley 370 on at
    Re: How can a let external people connect to dataverse?

    The best way is to go the advanced settings in the environment, where there is a Developer page.

     

    Go to <orgname>.api.crm4.dynamics.com/main.aspx?settingsonly=true

     

    and then bring down the menu at top, and go to Customizations / Developer Resources, where all the URLs are defined for the API.

  • naaatthh Profile Picture
    naaatthh 22 on at
    Re: How can a let external people connect to dataverse?

    Thanks @mjburley 

     

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes happening today, December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans