Fetching items failed error inside a ForAll

(0) Share

Report

Posted on by andrea_ginocchi

Hi everyone!

This is my code but it's not working, can you please tell me why?

ClearCollect(
 tmpUserInterest,
 Blank()
);
ForAll(
 db_Users,
 If(!IsBlank(Tag_select.Selected.Interest in Split(LookUp(db_Users,Email=ThisRecord.Email).Interessi,",")),
 Collect(
 tmpUserInterest,
 {User: ThisRecord.Email}
 )
 )
);

The error returned is:

The requested operation is invalid. Server Response: db_Users failed: Fetching items failed. Possible invalid string in filter query. clientRequestld: c4bReb0-0102-45da-9929-72967ea0fe39 serviceRequestld: c4bf7eb0-0102-45da-9929-72967ea0fe39

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @andrea_ginocchi , The Output of below code is Boolean
Tag_select.Selected.Interest in Split(LookUp(db_Users,Email=ThisRecord.Email).Interessi,",")
So, can you try this:
ClearCollect( tmpUserInterest, Blank() ); ForAll( db_Users, If(Tag_select.Selected.Interest in Split(LookUp(db_Users,Email=ThisRecord.Email).Interessi,",") = true, Collect( tmpUserInterest, {User: ThisRecord.Email} ) ) );
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
andrea_ginocchi 15 on at

Like (0)

Report
Copy link

Link copied!
Hi @ANB ,
thanks for replying.
Actually, an issue with LookUp insiede Split function still remains.

We fixed it with the following code:
ClearCollect( tmpUserInterest, Blank() ); ForAll( db_Users, If(Tag_select.Selected.Interest in Split(ThisRecord.Interests, ","), Collect( tmpUserInterest, {User: ThisRecord.Email} ) ) );
With "thisrecord.Interests" I am selecting a specific column of my DB, so it is not necessary to use LookUp function.

Was this reply helpful? Yes No