If your data requires formatting, create a second column using the TEXT () function to display formatting and send that data, not the original data. Power Automate only works with Excel Table objects.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

Structure data using table references to ensure formulas always reference the correct range. Key dynamic formulas include Spill Reference Operators, BYROW, LAMBDA, and Array Boolean Logic.

By using formulas, you can create dynamic text labels that update automatically as your data changes. Link chart titles or labels to cells containing dynamic formulas ...

Learn how to generate a truth table for logic circuits, boolean expressions, and propositional formulae using a Truth Table generator.