web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Error using CountRows ...

Power Apps

Answered

Error using CountRows of a list

(0) Share

Report

Report

Posted on by gasilva8

64

I'm trying to check if a value (which comes from a Variable) exists in a SP List.

I tried this, and returned true (I don't know if I used the correct syntax, but it worked!):

If(!IsBlank(LookUp('SPList', Variable = Column,"*"&Variable&"*"))

Now I'm trying to count rows if contains the Variable, but returns 0:

CountRows(Filter('SPList', Column = "*"&Variable&"*"))

How can I workaround that?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, what you have should work, are you trying to use wild cards though? e.g. "*"? does you data actual contain * e.g. "*MyValue*"

the below works for me but this will return a number so you would need to put it in a text property to view it

CountRows(Filter('SPList', Column = Variable))

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@gasilva8

For the first formula, you can use the following a little more easily:

If(!LookUp('SPList', Variable = Column,"*" & Variable & "*", true), ... )

In this case, LookUp will return true if the record exists.

Since CountRows is not delegable, it seems to sometimes ignore itself.

Try the following for your second formula:

With({_data: Filter('SPList', Column = "*" & Variable & "*")} CountRows(_data) )

I hope this is helpful for you.

Was this reply helpful? Yes No
C-Papa 1,836 on at

Like
a
(1)

Report
Copy link

Link copied!

Just to add to @RandyHayes, i think you missed a comma,

With({_data: Filter('SPList', Column = "*" & Variable & "*")},
CountRows(_data)
)

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@C-Papa

Yes, thank you...missed a comma. Not unusual when typing in formulas freehand.

Was this reply helpful? Yes No

Join the conversation