Author an advanced formula that uses tables, records, and collections in a canvas app in Power Apps knowledge check

1.

When using functions that process Tables of data, the table must come from?

Unfiltered data sources

Any data source but not collections

Single column tables only

The functions accept any table. The table might come from a tabular data source, a collection, or a Table function.

2.

The aggregate functions support the following inputs?

Only Table data with an expression - Example Sum(Table, Column1)

Only Manual data - Example Sum(1,2,3)

Both Table data and Manual data

Only Table data without an expression - Example Sum(Table)

3.

What function can you use in the formula for the ForAll function to overcome not being able to use Set and UpdateContext?

You can use Set and UpdateContext in ForAll.

You can use the Collect function.

You can use the ForAllVariable function.

You can use the Patch function.

Check your knowledge