John Liu Blog

Every drop counts

Power Automate retry policy interval setting

The Power Automate retry policy interval setting follow the ISO 8601 date format for durations. The ISO 8601 durations are expressed using following format, where (n) is replaced by the value for each of the date and time elements that follows the (n). P(n)Y(n)M(n)DT(n)H(n)M(n)S P is the duration designator (for period) placed at the start of the duration representation. Y is the year designator that follows the value for the number of calendar years.

Posted by John Liu Wednesday, February 28, 2024

Power Automate file contents base64

When using Power Automate flow to upload a CSV file to SQL server, the base64 value in the flow will be converted to a UTF-8 binary value if the target column data type is varbinary, or the raw base64 string value if the column data type is varchar/nvarchar. However, when the original data contains unicode string value like Chinese character, the varbinary data type will not be able to be converted back to its original unicode text.

Posted by John Liu Tuesday, March 29, 2022