Power Automate: Convert Excel Number to Date
When you’re fetching data from Excel, you would expect that Power Automate receives one from Excel. Both have the concept of dates, but something “strange” …
Skillful Sardine
Power Platform is a set of tools that enables everyone to become a developer. It comprises 4 parts: Power Automate, Power BI, Power Apps, and Power Virtual Agents. See where the “Power Platform” comes from? Also, it provides tools that enable you to connect to other parts of Microsoft’s ecosystem like Microsoft 365 (former Office 365), Dynamics 365, Azure, and much more.
If you read my articles, you’ll notice that this is a big focus area. It’s quite amazing what you can do when everything is taken care of for you. Not dealing with infrastructure, servers, code, developers, and much more is a blessing. You only need to bring your business expertise, and you can deploy applications in your organization. Also, you can make your own dashboards or save everyone time by building Flows.
When you’re fetching data from Excel, you would expect that Power Automate receives one from Excel. Both have the concept of dates, but something “strange” …
The Trim function is one handy function that most don’t understand the proper usage since it only serves one purpose. It is removing spaces. It …
The TrimEnds function is one handy function that is often confused by the Trim function since it works closer to the way developers are used …
A few weeks ago, I published an article going over an experiment that we did with timesheets that failed. You can read all about it …
Most of us use approval actions to collect feedback from a set of options, but were you aware that there’s another way to send a …
The filter function searches in a collection for one or more conditions and removes all items that don’t fit that condition. Usage It follows a …
When you publish your Power App, you should be aware that Power Apps are also available for mobile. Although this can be aside, though, having …
The split Function breaks down your string into an array of strings using the delimiter that you defined. Think of the delimiter as a border. …
Having Power Automates running is easy but making them fail-proof is not has hard it may look when compared with the benefits that it brings. As …
The toLower Function sets all items in a string to lowercase. There is the toUpper function also, and these functions are super useful, mainly if …