Skip to main content
  • Power Apps
  • Overview
    • Build Apps
    • Automate Processes
    • Connect Data
    • AI Builder
    • Portals
  • Pricing
  • Partners
    • Partner Showcase
    • Find Consulting Services
    • Find a Partner
    • Become a Partner
  • Learn
    • Documentation
    • Guided Learning
    • Support
    • Roadmap
    • Blog
    • Customer Stories
  • Community
    • Forums
    • Galleries
    • Ideas
    • User Groups
    • Community Blog
  • Register
  • ·
  • Sign In
  • ·
  • Help
Go To
  • Power Apps Community
  • Get Help with Power Apps (Formerly General)
  • Building Power Apps (Formerly General Discussion)
  • Common Data Service for Apps
  • AI Builder
  • Power Apps Governance and Administering (Formerly Administering Power Apps)
  • Power Apps component framework, ALM & Pro Dev
  • Power Apps Portals
  • Power Virtual Agents Forum
  • Community Blog & News
  • News & Announcements (Formerly Power Apps Community Blog)
  • Galleries
  • Community App Samples
  • Video Gallery
  • Canvas Apps Components Samples
  • Microsoft Business Applications Presentations
  • Ideas
  • Power Apps Ideas
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
  • Power Apps Community
  • Galleries
  • Community App Samples
  • #Challenge: PowerApps with two Data Sources

#Challenge: PowerApps with two Data Sources

02-10-2019 16:43 PM - last edited 02-11-2019 11:28 AM

SanAndresMan1
Level: Powered On
419 Views
LinkedIn LinkedIn Facebook Facebook Twitter Twitter
SanAndresMan1
SanAndresMan1
Level: Powered On

#Challenge: PowerApps with two Data Sources

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎02-10-2019 04:43 PM

This app showcases the use of 2 data sources within the same application, connecting to a Microsoft Dynamics GP on-premises company database in SQL Server and a Dynamics 365 for Sales cloud instance. 

In this case, we will display a customer list from Microsoft Dynamics GP and find the corresponding contacts in the Contacts entity in Dynamics 365 for Sales. 

 

SalesContact2Sources.png

If a customer is selected from the list, summary information is presented from Microsoft Dynamics GP, but contact information is retrieved from Dynamics 365 for Sales as shown below. The map is achieved by passing in the customer address to Google Maps. 

SalesContact2Sources2.png

In order to display the contact list from Dynamics 365 for Sales, a gallery has been added which simply displays the contact name and whether or not they would like to be contacted by email. A filter is applied to only display the correspoding contact for a specific customer record.

 

SalesContact2Sources3.png

SalesContact2Sources.png
Sales Contact - Two Sources.msapp
Labels:
  • Data connections and mashups
  • Formulas and controls
  • Galleries and forms
  • Mobile app design and user experience
  • Workflow and process automation
Message 1 of 1
419 Views
1 Kudo
Reply
  • All posts
  • Previous Topic
  • Next Topic

Power Platform

  • Overview
  • Power BI
  • Power Apps
  • Power Automate
  • Power Virtual Agents
  • Sign in
  • Sign up

Browse

  • Sample apps
  • Services

Downloads

  • Studio
  • iOS
  • Android

Learn

  • Documentation
  • Support
  • Community
  • Give feedback
  • Blog
  • Partners
  • © 2019 Microsoft
  • Privacy & cookies
  • Terms of use
  • Trademarks