Check if Collection Column have a value

(0) Share

Report

Posted on by indhaa

Pls let me know what is wrong with the below code

I'm checking two collections and if both are empty, I want the error to prompt.

But now it is validating this code and submitting the form even if the collections is empty

If(
 CountRows(
 Filter(NewCollection,
 Or(
 IsBlank(A),
 IsBlank(B),
 IsBlank(C)
 )
 )
 ) && 
 CountRows(
 Filter(EditCollection,
 Or(
 IsBlank(D),
 IsBlank(E),
 IsBlank(F)
 )
 )
 ) > 0 ,
 Notify(
 "Admin Role is required",
 Error
 ),
 SubmitForm(Form))

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@indhaa

You are logically And'ing (&&) two numeric values...this will not give you the results you want.

Change your && to plus ( + )

If( CountRows( Filter(NewCollection, Or( IsBlank(A), IsBlank(B), IsBlank(C) ) ) ) + CountRows( Filter(EditCollection, Or( IsBlank(D), IsBlank(E), IsBlank(F) ) ) ) > 0 , Notify( "Admin Role is required", Error ), SubmitForm(Form))

I hope this is helpful for you.

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report

Randy,

I want if either count is true then the condition is true. In that case how will the code be.

So I'm checking if countrows of NewCollection >0 or countrows of EditCollection >0 .

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
I tried like this first
If( (CountRows( Filter(NewCollection, Or( IsBlank(A), IsBlank(B), IsBlank(C) ) ) ) > 0 ) && (CountRows( Filter(EditCollection, Or( IsBlank(D), IsBlank(E), IsBlank(F) ) ) ) > 0 ), Notify( "Admin Role is required", Error ), SubmitForm(Form))

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report

Hi @WarrenBelz

can help me out?

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
@indhaa ,

You we missing the >0 argument on the first part.
BTW @RandyHayes is probably asleep right now - we can only respond as time zone allows.

If( CountRows( Filter( NewCollection, IsBlank(A) || IsBlank(B) || IsBlank(C) ) ) > 0 || CountRows( Filter( EditCollection, IsBlank(D) || IsBlank(E) || IsBlank(F) ) ) > 0, Notify( "Admin Role is required", Error ), SubmitForm(Form) )

Please also take some time to understand the logic when you get a solution - it will help you greatly for the future.

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.

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report

Yah, I assumed @RandyHayes was asleep that's why I tag you since I get response from you at this time and was hoping you will respond even if it is Sunday.
I was hoping to live the app today, sorry for disturbing on a Sunday. I will check this out

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Hi,

Hope you are available
So I added as below. Even if the Edit collections is not Empty it is not submitting the form when the NEW collection is empty. I tested by keeping only the Edit Collection and it submit in that case.

So I tried by changing by putting the Edit Collection first and then the New but still it doesn't work. Only if New Collection is not empty it is submitting. I don't know why since I cant see any issue with the code.

Pls Let me know what I'm missing

If( CountRows( Filter( NewCollection, IsBlank(A) || IsBlank(B) || IsBlank(C) ) > 0 || CountRows( Filter( EditCollection, IsBlank(D) || IsBlank(E) || IsBlank(F) ) > 0, Notify( "Admin Role is required", Error ), SubmitForm(Form) )

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@indhaa ,

Problem with free-typing code on a Sunday - that syntax should be invalid as it is missing two brackets - I have fixed it on the original post

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.

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

Like (0)

Report
@indhaa

Yes...sleeping! Start of a Sunday morning here now.

Did you try the formula I provided you? (slightly revised version below)

If( ( CountRows(Filter(NewCollection, Or(IsBlank(A), IsBlank(B), IsBlank(C))) + CountRows(Filter(EditCollection, Or(IsBlank(D), IsBlank(E), IsBlank(F))) ) > 0 , Notify("Admin Role is required", Error), SubmitForm(Form) )

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Hi

The code for the Form.Edit part is still not working .

Even if the Edit collections is not Empty it is not submitting the form when the NEW collection is empty.

I tried testing by changing "||" to "&&". It does submit the EDIT Collection when I changed to that but when I delete all the records in the collection it does submit like that too without ANY collections data.

If I put the same collections twice in the code it is working but if I put the two collection, it just say missing New Collection.
Even if EDIT Collection is not there, NEW collection can be submitted but NOT the other way around.

If(Form.Mode = FormMode.New, If( CountRows( Filter(NewCollection, Or( IsBlank(A), IsBlank(B), IsBlank(C) ) ) ) > 0, Notify( "Admin Role is required", Error ), Notify( "Success", Error ) ), Form.Mode = FormMode.Edit, If( CountRows( Filter( NewCollection, IsBlank(A) || IsBlank(B) || IsBlank(C) ) ) > 0 || CountRows( Filter( EditCollection, IsBlank(D) || IsBlank(E) || IsBlank(F) ) ) > 0, Notify( "Admin Role is required", Error ), Notify( "Success", Error ) ); )

Was this reply helpful? Yes No