Issues with IsBlank(LookUp()) inside of AddColumns (Unanswered)

(0) Share

Report

Posted on by Tomasteixeira

I have the following ClearCollect function:
 
ClearCollect(
    locTableCourses,
    AddColumns(
        Filter(gblTableCourseJourneyPairs, 'Journey ID' = locRecordLearningJourney.ID), 
        Course,
        LookUp(gblTableCourses, ID = CourseID),
        Completed,
        Not(IsBlank(LookUp('Completed Courses', Title = User().Email && 'Course ID' = CourseID)))
    )
)
 
However, whenever I run this, I get the following error message:



"Error when trying to retrieve data from the network: Fetching items failed. Possible invalid string in filter query."
 
The issue seems to be with the "IsBlank()" section. If I remove the "Not(IsBlank(" so that it simply returns a record, it runs fine. However, later if I try to do "IsBlank(ThisRecord.Completed)", it'll throw the previous error message again.
 
Does anybody know what's going on here and/or how I can fix this? I appreciate any help with this!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Power Platform 1919 2,217 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Tomasteixeira, can you please share what data sources are used?

Can you try this formula (replace Col_Name with any column of 'Completed Courses' data source).

Note this is a free typed code (error might come)

ClearCollect( locTableCourses, AddColumns( Filter(gblTableCourseJourneyPairs, 'Journey ID' = locRecordLearningJourney.ID), Course, LookUp(gblTableCourses, ID = CourseID), Completed, LookUp('Completed Courses', Title = User().Email && 'Course ID' = CourseID).Col_Name<>Blank() ) )

Was this reply helpful? Yes No
Tomasteixeira 14 on at

Like (0)

Report
Copy link

Link copied!

@Power Apps 1919 What do you mean by share the data source used? The data is from Sharepoint Lists if that's what you mean.

The solution you provided gives the same error message unfortunately. Additionally, when verifying the collection through the Variables tab, the 'Completed' column has question marks everywhere

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 2,217 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Tomasteixeira, can you try this once.

Note this is a free typed code (error might come)

ClearCollect( locTableCourses, AddColumns( Filter(gblTableCourseJourneyPairs, 'Journey ID' = locRecordLearningJourney.ID), Course, LookUp(gblTableCourses, ID = CourseID), Completed, CountRows(Filter('Completed Courses', Title = User().Email && 'Course ID' = CourseID))<>0 ) )

Was this reply helpful? Yes No
Tomasteixeira 14 on at

Like (0)

Report
Copy link

Link copied!

@Power Apps 1919 this also gives the same issue

Was this reply helpful? Yes No
Power Platform 1919 2,217 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Tomasteixeira ,
is 'Course ID' a lookup column?
If possible, can you share the Schema of the SharePoint Lists , which are being used

Was this reply helpful? Yes No