Answered

Filtering SharePoint List by ID Value

(0) Share

Report

Posted on by RupertCoyb

Hi,

Within a ForAll loop, I'm trying to build a collection from a SharePoint list using the ID of the SharePoint list, against the ID of the current record. I'm getting an incompatibility issue though (Table vs Number):

I can't cast the first ID to a value, so I'm not sure what I'd be able to do in this case.

I also seem to be getting a delegation warning which I wasn't expecting.

If anyone has some tips I'd be very grateful!

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

try ID = ThisRecord.ID

you have already referenced the date source in the filter, you don't need to do it again.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RupertCoyb，

As @C-Papa said that you should refer to the ID directly. I think this could solve your formula issue directly.

You could mark the reply from @C-Papa as an answer.

As to the delegation issue, not sure about the data set in the SP list. If the records does not exceed the 2000, you could just ignore the delegation warning because it does not effect the app performance.

You could also modify the records limit from 500 to 2000 in the advanced settings as below:

To avoid the delegation warning, you could use the With() function.

Was this reply helpful? Yes No
RupertCoyb 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @C-Papa and @v-qiaqi-msft for your replies on this. It seems to be working as I would like it to now.

Unfortunately, the list is likely to exceed 2000 records so I'll look into the with() function to see if that can help.

Thanks again!

Was this reply helpful? Yes No