CountRows not working properly - how to re-write the code for same result

(0) Share

Report

Posted on by MIA27

I am developing app in teams power app.

Data in the tables, having only 128 records

I wanted if the gallery filter count = 1 then false and

If no record then true

I have the below code on select event of the Gallery control.

Some time it works, some time it hangs, no result.

I click here there on the screen and then on the gallery filtered item again, then it works,

Could not understand, why it hangs for the result of true or false

Does it need to write in another way to obtain the true false result

If(
 CountRows(
 Filter(
 TableMachRemarks,
 Model = SearchResultGallery_4.Selected.Model && SerialNo = SearchResultGallery_4.Selected.Serial
 )
 ) = 1,
 Set(
 gblRemarksNewRecord,
 false
 ),

 CountRows(
 Filter(
 TableMachRemarks,
 Model = SearchResultGallery_4.Selected.Model && SerialNo = SearchResultGallery_4.Selected.Serial
 )
 ) = 0,
 Set(
 gblRemarksNewRecord,
 true
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (3)

Sort by

IAmIntractable 280 on at

Like (0)

Report
Copy link

Link copied!

If(
CountRows(
Filter(
TableMachRemarks,
Model = SearchResultGallery_4.Selected.Model && SerialNo = SearchResultGallery_4.Selected.Serial
)
) = 1,
Set(
gblRemarksNewRecord,
false
),
Set(
gblRemarksNewRecord,
true
)
)

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

I tried the code which you mentioned, the result was same, then added that getting 0 coding part.

Any other idea to get this done

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,994 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@MIA27 ,

Try

Set( gblRemarksNewRecord, IsBlank( LookUp( TableMachRemarks, Model = SearchResultGallery_4.Selected.Model && SerialNo = SearchResultGallery_4.Selected.Serial ).Model ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

Dear Mr. Warren,
Thank you. Applied the code, it worked.

As the code is applied on select event of Gallery, One thing I noticed that when it is false, the screen textbox value based on true or false get updated immediately.
But when it is true, it need to click on the gallery manually - to run the Onselect event.

Is it possible we can improve the code, so that in both situation it get in action without manually clicking on the gallery item. For example something default of gallery can be done .

Please guide if possible, as true action is not getting into action

regards

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,994 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@MIA27 ,

Your search criteria contains SearchResultGallery_4.Selected, so you need to select a record to gain access to the relevant fields in it. You could look at making the Gallery Default reflect the record you want selected, so whatever your Gallery Items is, wrap it in First() and put this on the Default.

First( YourGalleryItemsHere )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!
As the code is running on the gallery SearchResultGallery_4 on which on select event code is been applied to obtain True or false,
you mean in the same gallery SearchResultGallery_4 - , on its default property i need to put the code like below :
Just confused, please clarify :

First ( Set( gblRemarksNewRecord, IsBlank( LookUp( TableMachRemarks, Model = SearchResultGallery_4.Selected.Model && SerialNo = SearchResultGallery_4.Selected.Serial ).Model ) ) )

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,994 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@MIA27 ,

I meant the Items of the Gallery - that appears to be the OnSelect

Was this reply helpful? Yes No