cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
New Member

Hello Techies/Readers,

  
This blog will teach you How to connect Business Central Data in Power Apps.
 
Check below step by step process.
 
Step 1:- 
 
Go to the home.dynamics.com and then Open PowerApps.
 
DynamicPower101_0-1609254231161.png

 

Step 2:-
 
Now as you can see in below image, we are on the home page of PowerApps, if you have good knowledge of PowerApps then you can directly create PowerApps by clicking on the options under "Make Your Own App" and if you are beginner then skip this step and follow Step 3.
 

DynamicPower101_1-1609254231163.png

 

Step 3:-
 
If you want to connect your data with in-built Microsoft provided sample app then choose "Other Data Sources".
 
DynamicPower101_2-1609254231168.png

 

 Step 4:-
 
Now click on + New Connection and select "Business Central".
 
DynamicPower101_3-1609254231165.png

 


DynamicPower101_4-1609254231158.png

 

Step 5:-
 
As you can see in below image, we have created connection with business central, now PowerApps asking us to choose the Environment (Data Set).
 
DynamicPower101_5-1609254231166.png

 

Step 6:-
 
After selecting the environment PowerApps asking us to choose entity to create demo app. For this example, we have chosen vendors Entity/Table.

DynamicPower101_6-1609254231164.png

That's it, we are done with our first sample app, now see how it looks like.

 

Output: As you can see in below image, PowerApps created one demo application for us with the entity vendor.
 
DynamicPower101_7-1609254231167.png

 

This one was demo app where I demonstrate to connect Business central data with Power Apps, now based on that I have created one proper Power App in which I have used Business center Role center, List and Card page of Vendors, Purchase orders and Purchase Invoice and Inventory modules. You can say Business Central Important modules integrated with Power Apps.
I know you are thinking that how we can integrate this, correct?? don't worry I will explain this in my next Blog meanwhile you just checkout this exclusive sneak peek.
 
Entry Level Page:
 
DynamicPower101_8-1609254231170.png

 

 
Home Page (Role Center)😞

DynamicPower101_9-1609254231166.png

 

 
List Page of Vendors:

DynamicPower101_10-1609254231169.png

 

 
Card page of Vendor:
Read more...

Kudo Kingpin
Kudo Kingpin

Within our organisation we have a number of Power Apps developers who have learned their trade by working on voluntary projects that solve different business and social challenges. It's always great to learn by applying yourself to a specific goal, and it's even better to be able to give something back in the process.

The advantage with Power Apps is that you can produce solutions so quickly that it's worthwhile even if it only solves a niche problem.

In this post I'm going to describe one of those niche solutions, the problem it solves, and the decisions that went into designing it. Design is important to us both technically and visually – we want our user experience to be great, and as a result our solutions often don't look like PowerApps.

Read more...

Dual Super User II
Dual Super User II

In this article I will show you how to create a re-usable calculator control component in PowerApps. We will use buttons and text label controls to create a responsive calculator as a custom component with low code no code.

Read more...

Dual Super User II
Dual Super User II

In this article I will highlight 10 interesting PowerApps hacks/ workarounds/ troubleshoots that might help you in building canvas apps. This article is inspired by a couple of questions that I have been repetitively seeing on the community forums. Being documented at one place, it could be a good cheat sheet for all level of users (beginners/ mid/ pros) while building apps.

Read more...

Solution Supplier
Solution Supplier

Sometimes, when we add data cards columns in form, then for better user interface we need to adjust its X and Y position which is very tedious task. Or, we can used snap column feature. but that didn`t so much helpful.

 

So, to solve this type of issue, there is a way. 

  1. Create a blank custom data card.
  2. Create text input field within the new custom data card, you can create multiple fields based on your requirement and puts all in the same custom data card (you can set its width and height accordingly, as per your design). You can drag and set your UI on within that custom data card.
  3. Now, on the field data card sets its 'Update' setting to textinput.text and the hide this field data card.

 

That is the simplest and best way to adjust your UI of the form.

 

Thanks,

Prashant

  

Read more...

Dual Super User II
Dual Super User II

In this article I will show you how to shoot a video in PowerApps. I will pass the data collected in a collection from a Camera control and a Microphone control from the canvas app to an Azure Storage blob via Flow. I will then use those to reference to an external API and finally create the video.

Read more...

Impactful Individual
Impactful Individual

A button in PowerApps has a "OnSelect" property but no "OnDoubleSelect" property. So is it not possible to have a double-click event in PowerApps then? But it is possible, with a little bit of extra effort. This blog post shows you how to add double-click functionality to a button in PowerApps. At the end, a video is shown for a more visual explanation.

Read more...

MVP

This is a continuation of the Business Card Scanner using Microsoft PowerApps vBlog I had recorded back in August, 2018. This blog walks you through step-by-step to build the key features you need. Majority of the explanation is done in the video, this blog provides formulas and links to helpful articles.

Read more...

Impactful Individual
Impactful Individual

Not to long ago, Microsoft introduced the column type “Location” in SharePoint Online. This is a great addition for business solutions. From a PowerApps perspective, the usefulness is limited to showing data (Country/Region, State, City, Postal Code and Street).

 

So is it not possible at all to update a location field from PowerApps?

Read more...

MVP

This blogs focuses on how to add defaults to a SharePoint Customized (or PowerApps) form. The list in this demo includes all the column types including managed metadata. The video walks you through the steps in detail, however, this blog contains all the functions incase you want to copy and paste

Read more...

MVP

This blog focuses on the on offline capability of PowerApps. Here you'll see the key features you need to add to your PowerApp in order to take input when there is no internet connection available and automatically upload it to your data connection. This written blog explains the features and the formulas/expressions used. The video deep-dives in the entire process. A copy of this app is attached to this blog.

Read more...

MVP

This blog walks you through how you can use PowerApps in Power BI to save a snapshot of data available in a Power BI Report. In addition, we will add the option to add a comment.

Read more...

Impactful Individual
Impactful Individual

It is recommended to update or (re)publish your app every six month. Click here to go to the related webpage. To be honest, I do not know if this it true for SharePoint forms (I assume it is), but for apps it is recommended.

 

So how does one know which apps are not updated or (re)published in six months? Well, PowerShell to the rescue!

Read more...

Super User
Super User

See PowerApps in action on multi-step Business Workflow Processes, that isn't hard-coded.

Read more...

MVP

This article and accompanying video shows how with a little imagination, you can leverage recent managed metadata support in PowerApps in new and interesting ways for tagging content. Also learn some nice tricks around the use of canvas controls and relative positioning of controls

Read more...

MVP

This blog briefly talks about the main features used to build the vertical menu which will horizontal expand and collapse. A copy of the MSAPP has been attached for you to download and explorer.

Read more...

Super User
Super User

Easily create multiple column based filters on any gallery or data table, while adding additional choices for items like "-All-", "-Me-", "-Today-" without having additional checkboxes, logic or if statements to get lost in.

Read more...

MVP

4 years ago I had written a TechNet Guru Award in the SharePoint category for writing an article on 'SharePoint Online: A no-code Solution to Create and Customize Access Service app using Access 2013'. Now I am going to migrate this Access App to PowerApps.  There is some urgency when it comes to migrating Access Apps because Microsoft has already stopped creation of new Access-based apps in SharePoint Online one June 2017 and will shut down any remaining apps by April 2018. For more information you can refer to the 'Updating the Access Services in SharePoint Roadmap'. You can also refer to the 'Introduction to PowerApps for Access Web Apps' developers document.

 

In this section I will focus on building the core design of the PowerApp and build the View Forms.

Read more...

MVP

4 years ago I had written a TechNet Guru Award in the SharePoint category for writing an article on 'SharePoint Online: A no-code Solution to Create and Customize Access Service app using Access 2013'. Now I am going to migrate this Access App to PowerApps.  There is some urgency when it comes to migrating Access Apps because Microsoft has already stopped creation of new Access-based apps in SharePoint Online one June 2017 and will shut down any remaining apps by April 2018. For more information you can refer to the 'Updating the Access Services in SharePoint Roadmap'. You can also refer to the 'Introduction to PowerApps for Access Web Apps' developers document.

 

This will be a multiple-part series on how the migration occurred. In this section I will demonstrate the Access App and then migrate it to SharePoint Online.

Read more...

MVP

This blog shows how PowerApps can be used to lookup values from an Excel spreadsheet stored on OneDrive, make multiple selections and then save it back to the Excel. 

Read more...

MVP

PowerApps is so much more than just a web based form and this blog will demonstrate that first hand. Here we are building a powerful tablet app where users can watch the planets of our Solar System revolve around the Sun. The app gives the users the option to filter out any of the planets they don't wish to see while they are still revolving.

Read more...

MVP

This article walks you through how to build a message or dialgue box

Read more...

MVP

What this 4 minute video to demo what the blog has to offer!

Read more...

Helpful resources

Meet Our Blog Authors
  • PowerApps Community Mentor 2018, Practicing surgeon and former Professor of Surgery, University of Illinois, Chicago.
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 12 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Systems developer
  • My name is Timothy Shaw and I create digital solutions using the Power Platform, Office 365, and Azure SQL and handle the IT for a small company in the energy sector. When not building the future :), I enjoy playing guitar, good (or really bad!) sci-fi, Xbox therapy, and hanging with my wife and son. Twitter: @ShortForTim
Join Blog
Interested in blogging for the community? Let us Know.