Using IsBlank() & <> will cuase my filter to raise this error "Error when trying to retrive data from network: Fetching items failed. Possible invalid siring in filter query"

(0) Share

Report

Posted on by johnjohnPter

1,811 Super User 2024 Season 1

I have this formula to filter SharePoint list:-

ForAll(relatedNetworkIDsFortheCurrentBookingCalendar, 
 
 Collect(colDelegableresults,Filter(BookingCalendarNetwork, 
 ActiveStatus.Value ="Active" And
 'Network ID' = ThisRecord.ID And (IsBlank(varBKID) Or 'Booking Calendar ID'<>varBKID)
 ))
);

but i am getting this runtime error on it :-

any advice?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @johnjohnPter ,

To get more details on this error and what in your formula may cause the issue, I suggest using Monitor. More information on how to use Monitor can be found here: https://learn.microsoft.com/en-us/power-apps/maker/monitor-canvasapps

Was this reply helpful? Yes No