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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Search database and cr...
Power Apps
Answered

Search database and create record in CRM

(0) ShareShare
ReportReport
Posted on by 8

Hi,

I have the following requirement and wanted to check the feasibility of using PowerApps to achieve it:

  1. Our solution needs Dynamics 365, naos portal, Staging DB and a tool (probably PowerApps) to update data from DB in CRM
  2. ‘Project’ data is stored in a staging db. On a need basis, CRM user can pull data from db into CRM. (Project records which are present in CRM, GUID is updated in db)
  3. When user clicks on new button on project entity in CRM, tool should be triggered. User can enter project name and a combination of other fields in the tool and search for record in db.
  4. If the record is found in db (but not present in CRM), user has the option/button to create that record in CRM.
  5. If the record is present in CRM, a link should be present in the tool to open the CRM record.
  6. The tool can also be triggered from portal. (for example, if there is a lookup field of Project on portal, tool should open)
  7. Direct creation of project is not allowed.
  8. All portal users are not CRM users.

Also wanted to know how the authentication model will work for PowerApps when opening from CRM and from portal.

Categories:
  • Verified answer
    v-micsh-msft Profile Picture
    Microsoft Employee on at

    Hi @shwetapathak,

     

    I will try to answer some of your questions:

    1. PowerApps supports all RESTFul APIs, if you would like to connect it to the staging DB, make sure the DB supports REST API.

    3. integrating PowerApps within Dynamics 365 button (or something else) may not available currently,

    8. PowerApps is only available for the users within the same organization, currenlty it is not available for external users to use it.

    For other steps, I think that should be mostly related with data operations.

     

    As your scenario is mostly related with Dynamics 365, it is recommended to seek help from the following forum:

    https://community.dynamics.com/enterprise

     

    Take a look at the following article to gain a basic understanding that how PowerApps would work with Dyanmics 365:

    Connect to Dynamics 365 from PowerApps

     

    Regards,

    Michael

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 409 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 252 Most Valuable Professional

Last 30 days Overall leaderboard