“I’ve got a date in my local format, but I have to convert it to ISO to save it into SharePoint, how to do it in Power Automate?”
Category: Expressions
Update SharePoint column only if there’s a value using Power Automate
“If the optional SharePoint fields are left blank the update via Power Automate in the second list overwrites the field to a blank value.”
How to add only working days to a date using Power Automate
“Can I let Power Automate to add only working days to a date, without the need to manually select the end date?”
How to calculate difference between two times in Power Automate
“I’ve got two times, the task start time and end time, how do I calculate a difference in minutes or hours with Power Automate?”
Why is Power Automate sending an HTML table even when it’s empty?
“I use Power Automate to send emails with HTML table, but it keeps sending them even when the table is empty, how can I avoid that?”
How to display date in your local language with Power Automate
“Power Automate gives me always the day and month name in English, is there some way how to convert the date to my local language?”
Most common reasons for an invalid expression in Power Automate
“Power Automate tells me that “The expression is invalid” but it doesn’t tell me what’s wrong, how can I fix it?”
How to split string by the first space in Power Automate
“My string has the data after an id number and a space, how can I split it by the first space and process only the data with Power Automate?”
How to format numbers (currency, percentage,…) in Power Automate
“I’m using Power Automate to send an email with proposal after it’s approved, but the numbers format for price and percentage look terrible.”
Get previous value(s) of SP multiple selection columns in Power Automate
“The previously described solution works fine, but Power Automate returns an error on a multiple selection columns, how can I fix it?”