Answered

data type is optioanl, countrows() error

(0) Share

Report

Posted on by Bingqiling

321

There is a field where the data type is optional '라이선스 유형'.
However, there is no option set name. I don't have permission to add an option set name, so I have to use it to develop it.
And among the data in the gallery element, there is option 1 (Processional), and I want to express the quantity of that data by adding a text label element. There is an error.

Concatenate( "Professional: ", CountRows(BrowseGallery1.Selected.'라이선스 유형'.'Professional' ))

a problem
The content of the error is not named correctly. 'Professional' is not recognized.
This error usually occurs when you refer to an item that does not have an expression (for example, a control that you deleted).
How to modify
Remove or correct references to invalid names.

Categories:

Building Power Apps

All responses (2)

Answers (2)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Bingqiling ,

Do you want to count the number of items in gallery which '라이선스 유형' option is "Processional"?
Please try this:
Concatenate( "Professional: ", CountRows(Filter(BrowseGallery1.AllItems,'라이선스 유형'.Value="Professional" )))

Best regards,
Rimmon
Verified answer

Bingqiling 321 on at

Like
a
(1)

Report
Copy link

Link copied!
Concatenate( "Professional: ", CountRows(Filter(BrowseGallery1.AllItems, Text('라이선스 유형') = "Professional" )))
@v-mengmli-msft Thanks, I didn't know I had to hang the filter.
I couldn't value it, so I changed it to Text and succeeded
It's by your favor.