Power Automate: How to access Excel with a dynamic path
by One of the questions I see a LOT is the Power Automate Forum are issues with accessing Excel files where you provide a dynamic path. …
Category: Microsoft
Microsoft if the global area that will encompass a lot of sub-categories. You’ll find articles on Microsoft Power Automation, PowerApps, SharePoint and reference materials for each of these areas. You’ll also find other specific reference articles that focus on particular features of each of the platforms mentioned.
Articles will come out every Tuesday and reference articles every Friday always at 7 pm Lisbon Time.
This schedule will enable me to balance the articles related with the three major platforms that I’m targeting (Power Automation, PowerApps, and SharePoint) as well as give you some reference articles for each of them that I think will help you understand better the basics of each platform.
PowerApps: Now Function
The PowerApps Now function will return the current moment’s date, including the time. PowerApps converts the value automatically to the user’s regional settings when displaying it …
Power Automate: Invalid Connection
Some days ago, I started having issues in all my flows, seemingly out of nowhere. I was getting Invalid Connection errors, all of them related …
PowerAutomate: addMinutes Function
The addMinutes Function works just like the addSeconds Function and other similar functions. It adds the number of minutes to a specific date, based on a …
Power Automate: How to not go insane dealing with email
When it comes to time drains, dealing with email is always at the top of the list. We all receive way too many emails, and …
SharePoint: Now Function
The SharePoint Now function will return the token serial number of the current date and time. Dates are stored internally as sequential serial numbers to enable …
PowerApps: Round Function
The Round function performs the mathematical round of a number to a specific number of decimal places. It uses the rules defined “Half Round-Up” where it rounds …
Flow: addDays Function
The addDays Function works just like the addSeconds Function and other similar functions. It adds the number of days to a specific date, based on a …
Power Automate: Using flow as a Web Service
Usually, we think of Power Automate as something that is triggered when something is changed or created, or even as a button that we press …
SharePoint: Today Function
The SharePoint Today function will return the number of elapsed days since a reference date, in this case, December 31, 1899 (serial number 1). These are …