Create PowerApps Application with On-premises SQL Server
PowerApps is a one of the powerful low code applications from Microsoft, which helps to develop millions of applications within a minute. Only platform which allows technical and non-technical to implement application with their requirements. Power platforms can be developed to receive data from different data sources like Excel, SQL server, share point resources and data from different cloud storages like Google, OneDrive, etc. Considering OnPrem data sources we do traditional coding to connect the application with the data source. But here we have a possibility to develop a PowerApps and receive data from On Prem SQL server. In this article I will show you how to connect OnPrem SQL to PowerApps. Pre-Requites 1) OnPrem SQL Server 2) PowerApps Subscription 3) On-Premises Data Gateway 4) Internet Connection On-Premises Data gateway for Power Apps On-Premises gateway is a bridge which provides most secure communication in between local sources to cloud applications. To know and learn more about On-Premises data gate way: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/gateway-reference SQL Server on Windows 10 Machine I have SQL database installed on my Windows 10 machine, which is a local machine with the active internet connection. If you are new to SQL server installation and configure, I have shared some other posts which will show you how to install and configure SQL server 2022 in your test environment. Download SQL Server 2022: https://info.microsoft.com/ww-landing-sql-server-2022.html?culture=en-us&country=us To Confirm your Installed Version: SELECT @@VERSION I have created a table named Demo Data and inserted some sample data Let’s configure the On-Premises Data Gateway To Download the On-Premises Data Gateway for PowerApps please download the Gateway from below link — https://powerapps.microsoft.com/en-us/downloads/. Once it’s downloaded install it to the local machine, it will take some time to install. When installation succeed it will prompt a dialog box to enter the Microsoft account details. Use the same account which you used to create PowerApps. In the next step create a Gateway with the valid security and recovery key. Here I named my gateway as DEMOPOWERAPPS Create Configure button to apply the configurations and close the dialog box, now it’s done. Now it’s time to build the app in PowerApps Go to PowerApps portal to make the app — make.powerapps.com I am going to create the PowerApps with SQL data source Click the SQL and add the New Connection and select the connection source as SQL database (SQL Server). In the authentication type select SQL Server Authentication from the drop-down list. In the source selection pane select Connect using on-premises data gateway as data source for SQL server SQL Server Name — Windows 10 Local PC Name SQL Database Name- POWERAPPSDEMO Username- demouser Password-[Your SQL User Password Here] In the bottom you need to select the installed gateway, here it will show the gateways you installed with the Microsoft account which you used to create the PowerApps. Here my installed DEMOPOWERAPPS gateway is listed and it’s showing, if your gateway is not listed, please refresh the gateway list. Once you select the correct gateway click create to link the data source to PowerApps. It will show the available tables once the gateway connection is succeeded, here my table DemoData is showing. I am going to use the DemoData table to connect with PowerApps. In case in the same database if you want to change or create new table you can either create it from here or choose different one. Click connect to link the On Prem database with PowerApps, It’s done and app is automatically created now. Without doing any additional changes in the app I will see the preview of the app to check to see whether it’s communicating correctly with the SQL database available at my laptop. The data which I entered manually using SQL commands are appearing here, it means it’s perfectly connected with the on prem SQL database. By adding an edit form in the PowerApps you can be able to insert the data from PowerApps to On Prem SQL Server. Just try this by yourself and let me know if you have any issues in connect On Prem SQL server to Power apps. Happy Coding!!
SharePoint site news notifications in Microsoft Teams channel
Dear Microsoft community, we are desperately trying to solve the issue since Microsoft stopped supporting the SharePoint News connector. We were trying to use the https://support.microsoft.com/de-de/office/sharepoint-news-connector-retirement-062bc8d1-b6f9-4716-a154-a6b9073d3461 that MS proposed but it's just not working. Can someone help me to setup a workflow that is posting the recent news in our news channel so that colleagues can start conversations about it? Thanks. Best Phil
SharePoint List Mobile Simple View not Using Selected Field
Hello, The SharePoint list my flow feeds into needs to be mobile-friendly, however whenever I configure mobile simple view for a view of the list, it will not display the field I selected, it only displays the Title field. Does anyone know why this might be? Any help would be appreciated! Thank you!
Alert when tasks are assigned to me across multiple SharePoint lists (private Teams channels)
Hello everyone, In my company we use SharePoint lists (not Planner) to manage tasks inside private Teams channels. Each project/team has its own task list, and people assign tasks to colleagues using the "Assigned To" column. My challenge: I would like to receive an automatic alert (email or Teams message) every time a task is assigned to me, regardless of which SharePoint list/site it comes from. The problem is: I don’t know in advance when someone will create a new list. Power Automate triggers (When an item is created or modified) need to be configured for each list individually. Planner/To Do integration would solve this, but Planner is not available for private Teams channels in our tenant. So, my questions are: Is there any way to catch all tasks assigned to me across multiple SharePoint lists without manually creating a flow per list? Are there any best practices for consolidating assigned tasks from multiple SharePoint lists into a single place (dashboard, notifications, central list, etc.)? Any advice, examples, or workarounds would be very welcome! Thanks in advance, Hugo CristinaFlow Action - Convert Word Document to PDF
I'm trying to use the Convert Word Document to PDF action in a Flow. There are three parameters that have to be entered: Location - the SharePoint Site Document Library - Library where the document is located. File - The document to convert The parameter that I'm having an issue with is the File. The flow works if I choose the specific document from the library but I want it to be dynamic so that when the user starts a Flow on the document it will convert that one, so I don't want to hardcode the document name. For the File property I'm using the property from a previous step with the file name called File name with extension. When I run the flow I get an error, "There was an error accessing the file. Please try again or select a different file." Can I not use dynamic content for the File property? ThanksWrong auto post message in Teams using power automate when 2 items are added at the same time
I have a power automate flow when an item is created in a sharepoint, it will post message in a Teams chat. But the issue is when two items are created at the same time (or in a short space of time) in a sharepoint, the teams message are posting the wrong content. anyone can help to suggest solution for this issue? Power Automate Flow: Sharepoint: Power automate - Run Success Power automate - Post message in Teams
Reference "File" from "For a selected Item" in SharePoint
Hello I got a SharePoint list (List A) where I run a "For a selected Item" event that collects text and a file (attachment) that I then use to populate a different list (List B). I can use the text to populate List B through "Create Item", but I haven't been able to "Add attachment". I've looked for the answer, but I haven't understood how to reference the file content and the file name to use "Add attachment". The "For a selected Item" gives the outputs as shown below: "Testing flow", and ContentBytes and Name for the file, but I can't use them to "Add attachment". I will very much appreciate your help. Leo
Add File Path to List of Extracted Data Fields
Good morning ... I am extracting pdf data fields to excel as they are uploaded to sharepoint sites. If anyone could advise how to add the specific file path (to the relevant doc) as another column in the row - I would sincerely appreciate it. Thank you again.
Sending a PDF file as an email attachment with Power Automate corrupts attachment
I have followed this great tutorial for creating and sending digital certificates to event participants (https://techcommunity.microsoft.com/t5/educator-developer-blog/send-digital-certificate-to-event-participants-in-8-easy-steps/ba-p/3697139), and everything worked except for the last step which is sending the email with the certificate attached. I am able to receive an email with the pdf attached however, the file is corrupted and I'm unable to open it. When I check the pdf file in my share point it is not corrupted so the issue seems to be in the step of sending the email. I tried using base64ToBinary(base64(body('Convert_file'))), when I added this I was able to open the pdf attachment but the pdf was empty and the content was erased. Please let me know if there is any way to overcome this issue.
