Notes - Power Automate

Tips

Variable inside a message

• You can use a variable on its own: =ExcelData
• Or you can add the variable inside a message: The data is: ${ExcelData}.

Loop number

• Start from: =1
• End to: =3
• Increment by: =1

If you type 1 in the Start from field, it will be treated as a string and cause error:

Expression must contain a 'Numeric value'

Excel row & column number

• Action: Read from Excel worksheet
  • Start Column: A
  • Start row: 1

fx

• Equal: = (If ‘=ExcelData = “”’ then)
• Calculate: =LoopIndex + 1

My machine doesn’t show out in the cloud flow

See doc

You can also install the machine-runtime app by following:

• Open Power Automate Desktop
• Settings > Machine settings > Open machine settings
• Install the machine-runtime app