Power Automate

Time/hour not correct with Power Automate and SharePoint

power automates sharepoint time not correct

When you get data from SharePoint into Power Automate and send the output to someone or another system, it can happen that the time is not correct. We created a simple flow that gets a list item from a SharePoint list, and sends the details by email. The first list item has time value 13:00 (or 1PM). Within Power Automate, …

Read More

Styling a HTML table in Power Automate

power automate css style html table

In one of my previous blogpost, we learned how to send a weekly report mail with data of a SharePoint list. The table was not so beautiful. There wasn’t even a border to separate columns or rows. We want to achieve a styled table: We have two ways to add styling to the table. The first way is the most …

Read More

Limitations of Project Oakdale in Teams

project oakdale limitations

Project Oakdale opens the road to a new data layer and many new features that were not available yet. Until now, we had following choices to store the data of a Power App: SharePointSQL (Premium connector)CDS (Premium connector)… Previously, CDS was premium. With Project Oakdale, you can use some kind of light CDS that is included in most of the …

Read More

Power Automate and Project Oakdale in Teams

power automate cds new item record

In my previous blogpost about Power Apps and Project Oakdale, we learned how to create an app with a many-to-many relationship using the new light version of CDS that was introduced together with Project Oakdale. In that blogpost, we created some tables. One of them is the “Company” table. It can occur that a company does not exist in the …

Read More

Secure inputs and secure outputs in Power Automate

power automate secure input secure output

The run history of a flow tells a lot about the data you are processing with your flow. Sometimes it can contain sensitive data. When you ran your flow, you see a lot of data when you click on an action. For this action, we don’t see sensitive data. But if you do a query on a list that contains …

Read More

“When an item or file is modified” trigger conditions

trigger conditions file item modified power automate

Power Automate and SharePoint already had an action to start a flow when an item/file was created or modified. But not yet an action for when an item is modified only. With this new “When an item or file is modified trigger” action, we can trigger a flow when for example a status column has been modified. A status column …

Read More

Generate a PDF in Power Automate without premium subscription

generate pdf power automate

I needed to generate a PDF in a Power Automate flow, without premium subscriptions. Using the Word actions was not an option because they are premium. Premium Word actions in Power Automate After thinking a little bit, I found out I could achieve generating a PDF by using a combination of following actions: ComposeCreate file (OneDrive)Convert file (OneDrive) Building the …

Read More