web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Set variable to true i...

Power Apps

Answered

Set variable to true if certain columns are empty

(0) Share

Report

Report

Posted on by _sourcecod3_

407

Hi all,

I'm working on setting a visibility of a button based on two conditions.

Example:

Condition 1: if column a, column b and colum c are empty, set variable1 to true.

Condition 2: if column d, column e and column f are empty set variable2, true.

Any help is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @_sourcecod3_ ,

I recommend that you use the CountRows function to count the number of empty records in a column and compare this number to the total number of records in the data to determine if the column is empty.
You can refer to this code to set the OnSelect property.

If(CountRows(Filter(datasource,a=Blank()))=CountRows(datasource)&&CountRows(Filter(datasource,b=Blank()))=CountRows(datasource)&&CountRows(Filter(datasource,c=Blank()))=CountRows(datasource),Set(vaiable1,true))
Hope this helps you!
-------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,299 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @_sourcecod3_ ,

The structure would be something like this

UpdateContext( { Variable1: ColumnA = Blank() && ColumnB = Blank(), Variable2: ColumnD = Blank() && ColumnE = Blank() } )

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

Join the conversation