Index Function

(0) Share

Report

Posted on by firda59

372

Hi,

I got 'ghost' error😭

I have patch function, I want to get my second largest data. I used this:

'Next Location': Index(Sort(
   Filter(
      AllRecapSOW, 
      'No. PO' = SOPOWBS_5.Text
        ), 'No Sec SOW', SortOrder.Ascending),
          2
).Area

Everything works well, but I dont know suddenly I got error "The 'Index' function cannot be called with an empty table."

Can anyone help me? Thankyou!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

gcmfaizan 1,022 on at

Like (0)

Report
Hi @firda59 ,

can you try this formula with CountRows function it's help you to encounter this error, your new formula may looks like this:
If( CountRows( Filter( AllRecapSOW, 'No. PO' = SOPOWBS_5.Text ) ) > 1, Index( Sort( Filter( AllRecapSOW, 'No. PO' = SOPOWBS_5.Text ), 'No Sec SOW', SortOrder.Ascending ), 2 ).Area, "No second largest data" )

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

@gcmfaizan

I try that formula, and I got "No second largest data". I think its because the SharePoint list has more than 2000rows. Do you know how to read data SharePoint list more than 2000?

Was this reply helpful? Yes No
gcmfaizan 1,022 on at

Like (0)

Report

@firda59 can you Verify the actual threshold configured in your SharePoint/powerapps? If it's lower than the default 5000. The threshold is set at 5000 items by default, but it can be lower based on the configuration and performance of your SharePoint/powerapps.

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

@gcmfaizan how to do it? I never do that before

Was this reply helpful? Yes No