Unanswered

Get Nth item if exists

(0) Share

Report

Posted on by Antonioclk

Hello,

I have a sharepoint list with N item. I want to get the Nth item but only if exists, otherwise i should get a blank or some sort of error.

It's a list of questions related to a game. Each game might have 10 questions but it might happen that some are not set, so i have to check for that.

Last(FirstN(Filter(mySPlist, chosedID=ID),2)));

I used this function but in this case, if the list have only one item, instead of giving me "blank" it gives me the first and only element of the list...

how can i achieve what I need?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Ash13 576 on at

Like
a
(0)

Report
Copy link

Link copied!
Are you looking for LookUp?

LookUp(mySPlist, chosedID=ID)

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@Antonioclk

You could consider calling the Index function. This will return an error if the Nth item doesn't exist.

Index(FirstN(Filter(mySPlist, chosedID=ID),2)),2);

You could wrap this around a call to IfError to return a blank rather than an error.

IfError( Index(FirstN(Filter(mySPlist, chosedID=ID),2)),2), Blank() );

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Antonioclk - can you confirm whether the formula above solved your problem?

Was this reply helpful? Yes No