Answered

Button to display total entries from O365 list

(0) Share

Report

Posted on by jster24

Trying to figure out how to get a button, or if there is something more appropriate than a button (?), to display the total number of entries from a SharePoint online list, based on filtering.

I don't need a sum of the total of data in the field, as they are not numeric fields. Just need to know how many entries there are based on todays date and if a column = no.

Can anyone lend a hand on how I go about doing this? I'm very green with powerapps!

Any help appreciated! Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Community Power Pla... on at

Like (0)

Report
Hi @jster24

To show a nubmer of records from datasource you can use
CountRows()
If you give us more info on what is your data structure and where it is held we can help you more.

In general you would put this function in a Label.Text property:

CountRows( Filter( YourDataSource, YourDateColumn = Today(), YourYesNoColumn = "no" ) )

Was this reply helpful? Yes No
Verified answer

jster24 62 on at

Like (0)

Report

@Anonymous thanks! You pointed me on the right path. I just had to tweak my column to have ".value" appended to it for PowerApps to accept it, and also used the CountIf function

CountIf('DataSource', Created = Today(), Column1.Value= "Select")

Was this reply helpful? Yes No