How to update a specific set of SharePoint list records after changing variables in Power Apps.
I have a timesheet app that captures start and end times. Within the associated SharePoint list, there are calculated fields. I have these fields included on the Power Apps form. The problem is that the calculated fields are not updating after the Patch action (updates or new saves). I tried the REFRESH action, but it is not refreshing the calculations. The only way I have found to view the updated calculations in the Power App is to filter the list to a different set of records, then back to the original. Once the filter returns to the original updated records, the new calculated results can be viewed. There has to be an easier way to do this.
Unable to add clickable link to Post Message in chat or channel
I'm trying to post to a channel when a Sharepoint list item is created. In the past, I had to manually enter the link in the html view and as long as I did not click back to the regular view the link would save and work correctly. Now, no matter what I do, as soon as I save the flow the dynamic link placeholder is converted to ']} Before saving after saving This is with the new designer, but I have also tried the classic designer.
Populating word template stored in Organizational Asset Library (OAL) using Power Automate
The objective is to implement an automated document generation solution that leverages the Microsoft SharePoint Organizational Asset Library (OAL) to provide users with standardized Word templates. These templates must dynamically self-populate with real-time identity data (Name, Email, Job Title, and Department, for now which can be extended) sourced from Microsoft Entra ID (formerly Azure Active Directory) upon instantiation. In other words, how to use a Word Template stored in Microsoft SharePoint Organizational Asset Library to populate with his or her own user information like Name, Email, Job Title, Department etc getting fetched from Azure Active Directory, whenever that user opens the template by going to File -> New -> Selecting Organization Tab and selecting the template. How can we populate this template using Power Automate?
Power Automate - iAuditor integration to Excel for business
Hi all, I'm trying to build a flow in Power Automate to feed data in Excel file (located on SharePoint) used for my Power BI report but i don't know why it does not want to work. This is my flow as shown in the photo In the first "For Each" action i have " body('Site') ", second " body('Serial Number') "..... When i test this is how it looks like If i remove the second and third FOR EACH, it goes to the excel action and stops there. Does anyone have a similar flow or does anyone know what i'm doing wrong? Thank you in advance if anyone has a solution.
Can we fill *.pdf in File Identifier on Get file metadata
Sir, I'm a rookie of Power Automate, so i'm tried to created flow to automatic fill metadata column in SharePoint Library as below. So, if i have specific file identifier, the flow was running successful, but if i have fill *.pdf then the flow was running fail. In fact, i cannot specify file identifier was uploaded in SharePoint but this flow must run automatically. My question is how to fix on this an issue? Many thanks for advice. Sonchai M. Flow Running fail
Repeating Table
All, i am creating a new Form for a Sharepoint list. I have one table with three fields that I only want to be filled out once. I have a second table with 7 fields. i would like for this table to be repeating, giving the person filling it out the option to add another set of the same 7 fields. Then upon saving/submitting, a new item is created in the SP list for each row in the repeating section. I have seen a couple of links in this forum but none of them includes a usable solution for someone like me who is very new to PowerApps.
Instant flow is not triggered
I have a power flow that should be triggered when new item is created on SharePoint list. New item was created on SharePoint list, but flow was not triggered. Issue started yesterday. I checked connections and they are active and are fine. Nothing was changed in the solution. Does someone know how to fix it?PowerApp forms get stuck on "Getting your data..."
Some, but not all of my SharePoint Forms that are built using PowerApps are getting stuck saying (Getting your data...". The strange thing is that sometimes the data will load then this will happen, or I can click out of the form and reopen it and then it will work. Anyone experiencing a similar issue?SharePoint Video Transcript Automated File Create and Download
For every video uploaded to SharePoint, transcripts are produced. However, we need a separate file (word document) containing the transcript text for each video. We can manually download the transcript for each video from SharePoint, but our aim is to automate this process. Ideally, every time a video is uploaded to SharePoint, a transcript would be generated, and the corresponding file would be automatically downloaded and saved in the same SharePoint folder. We attempted to use Power Automate for this task, but after several months of working with MS support and the Product Groups it seems that this is not feasible, and they do not intend to address this issue. I am hoping someone in this community can help us find a way to accomplish this goal using Power Automate.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!!
