“I received a multiple choice question from MS Forms that looks like an array, but Power Automate tells me it’s a string, how can I convert it?”
Category: Expressions
How to add SharePoint list into navigation with Power Automate
“I use Power Automate for creation of new SharePoint list(s), but they’re not added to the navigation automatically. How can I add them in a flow?”
Display SharePoint time in the correct time zone with Power Automate
“My Power Automate report contains SharePoint date & time field, but the time is off by a few hours, how can I display the right time {in my time zone)?”
How to add hyperlink in the ‘Create HTML table’ Power Automate action
“I’ve got all the items in a single HTML table, but I’d like to include also clickable hyperlink to the items, is that doable with Power Automate?”
How to split file name for further processing in Power Automate
“The files attached to an email have always the same file name format: ID_Type_User, how can I split it in Power Automate to get the information?”
How to send an instant message when your Power Automate flow failed
“I need to know asap if my Power Automate flow failed, I can’t wait a week for it to send a message or check daily the flow run history.”
How to add new line (‘\n’) to a string in Power Automate
“I am building a Power Automate flow and need to append values into a string variable, how can I add a new line/line feed into the variable”
How to format a date that can be empty (null) in Power Automate
“The Power Automate flow works fine if there’s a value for the date in Sharepoint, however, if it’s empty it’ll fail while trying to format the date.”
How to replace new line (‘\n’) in a Power Automate expression
“I can’t figure out how to replace a new line (‘\n’) or any other non-printable character in Power Automate expression.”
Format HTML table with SharePoint items in a readable way (Power Automate)
“The HTML table in an email from Power Automate is a mess, its format makes the SharePoint items I’m trying to show hard to understand.”