In Copilot Studio, you can use Power Fx expressions similar to Power Apps in various scenarios, such as asking questions, setting variables, or sending messages.
This time, I explored various aspects of these formulas.
Available Functions
The Power Fx functions available in Copilot Studio are only a subset of the full set (as expected, some functions like `PDF` or `SaveData` are not supported).
Official documentation on available functions can be found here.
Interestingly, functions like `Sequence`, which are not listed in the official documentation, can still be used. It’s worth trying even if a function isn’t listed.
Operators
All operators seem to be supported, including basic arithmetic operations, comparisons (greater than, less than), and even functions like `in`.
However, using string interpolation syntax seems a bit unreliable.
This may be because Copilot Studio’s code inherently utilizes string interpolation syntax.
Complex Formulas Are Possible
Functions listed in the official documentation, such as `ForAll` and `Filter`, are of course supported, but even functions like `With` can be used. This allows for writing relatively complex formulas.
*Example: Outputting a table of squared values greater than or equal to 6 from the first 10 natural numbers.
When writing longer formulas, click the expand button in the top-right corner for easier editing.
*For more information on using the With function, refer here.
コメント