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.
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.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
