web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / row or column passed t...
Power Apps
Answered

row or column passed to the Select function is outside the bounds of the gallery items

(0) ShareShare
ReportReport
Posted on by 427

There seems to be a bug in the function:

 

Select([Gallery],[RecordNum]) --> Select(Gallery_Quotes,1)

 

I have used this function to select the First record of a Gallery's collection, BUT even when the Gallery is populated, my Users see the error message:

 

"row or column passed to the Select function is outside the bounds of the gallery items" - which is clearly not true.

 

I suspect that this is another consequence of the extremely flawed "Formula level error reporting" feature that has been full of bugs and spurious/erroneous error messages since it was introduced. 

I have also noticed that this feature is now out of Experimentation, and in Preview status, which is very worrying, as there are clearly still some issues.

 

I believe the error is being thrown before the gallery has actually populated, so the Select formula thinks that there are zero records in the Gallery.

 

Please can you fix this faulty error reporting.

 

And in the meantime, can somebody point me towards the correct formula to use in the App.OnError function to suppress this spurious error message from hitting the Users?

 

Thanks

 

James.

Categories:
I have the same question (0)
  • Verified answer
    v-yujincui-msft Profile Picture
    Microsoft Employee on at

    Hi @james_hathaway ,

     

    Maybe you could try the following formula: 

    IfError(Select(Gallery_Quotes,1),"") 

     

     

    Best Regards,

    Charlie Choi

  • ManuelCoelho Profile Picture
    7 on at

    It won't select with the IsError

Under review

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 70

#2
WarrenBelz Profile Picture

WarrenBelz 64 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 36 Super User 2026 Season 1

Last 30 days Overall leaderboard