Index() function throws error

(0) Share

Report

Posted on by AV-16121501-0

Hello,

In a canvas app I am trying to retrieve a field value in a row from a collection, using the Index() function.

First, I've made a collection PeriodsFore with 9 values:

PeriodFore

202406

202407

202408

202409

202410

202411

202412

202501

202502

I am using the Index() function to retrieve one of the values in PeriodFore, for example Index(PeriodsFore,4).PeriodFore results in 202409. Function works ok, however PowerApps throws an error alert "The second argument to the 'Index' function must be between 1 and 8, the lower and upper bounds of the table. The upper bound may be reduced due to the non-delegation limit" at the top of the app. There is no error indication at the object where the Index() function is used.

What's the problem over here? Any clue is highly appreciated.

All responses (1)

Answers (0)

Suggested answer

ronaldwalcott 1,345 on at

Like (0)

Report

Index() function throws error

That just looks like a warning message indicating that Index cannot be delegated for a data source. You have a limit on the number of records that the function can be used on in a collection. You can ignore the message.

See documentation at https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-first-last#delegation