web

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

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps count double and display

Power Apps - Building Power Apps

Unanswered

count double and display

Like (0) Share

Report

Report

Posted on 4 Aug 2023 08:20:32 by Tysma12

7

Hello, i'm a beginner in PowerApp and i try to detect double in my table named CLIENT_CSPs and display the amount of double.

I already tried this but unfortunately this is not working :

CountIf(CLIENT_CSPs; cr3e4_name = ThisItem.cr3e4_name)

If you have any idea to solve my issue i'll take it

Thank you in advance for your help

Categories:

Connecting to Data

All responses Img

All responses (6)

Answers Img

Answers (0)

moritz0815 201 on 04 Aug 2023 at 13:05:15

Like (0)

Report
Re: count double and display

I have the following idea.
Use this as your text:

Sum(AddColumns(GroupBy(CLIENTCSPs,"cr3e4_name","ByName"),"Count",CountRows(ByName)-1),Count)

You may have to put cr3e4_name in { } so that the syntax fits.
Tysma12 7 on 04 Aug 2023 at 12:23:20

Like (0)

Report

Re: count double and display

CLIENTCSPs (it's not a public database)
moritz0815 201 on 04 Aug 2023 at 10:20:58

Like (0)

Report

Re: count double and display

What‘s your datasource?
Tysma12 7 on 04 Aug 2023 at 09:33:00

Like (0)

Report

Re: count double and display

PS : indeed the formula work in my galery (CLIENTCSPs) but the problem is that i need the amount of double in my dashboard and not directly in my table
Tysma12 7 on 04 Aug 2023 at 09:26:46

Like (0)

Report

Re: count double and display

In my case i need to display the amount of double in an entry on my dashboard (my CLIENTCSPs Table is on another screen). I tried too with a gallery as lable text but nothing change 😞
(On the picture linked the position where i need to put the amount of doubles)

Capture d’écran 2...
moritz0815 201 on 04 Aug 2023 at 08:49:58

Like (0)

Report

Re: count double and display

Did you write this formula as lable text in a gallery? The formula only works inside the gallery.