News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Count rows into lookup...

Power Apps - Building Power Apps

Unanswered

Count rows into lookup table

Like (0) Share

Report

Report

Posted on 13 Jun 2022 04:57:21 by raneesh_mr

55

I have SharePoint list Called "Workflow" another list called "Procuremetn Tracker".

One of the column (Status) in Procurement Tracker is lookup from Work flow.

In PowerApp i need total total count of each status in "workflow" gallery.

Categories:

General Questions

Connecting to Data

All responses Img

All responses (9)

Answers Img

Answers (0)

v-jefferni on 17 Jun 2022 at 02:22:27

Like (0)

Report
Re: Count rows into lookup table

Hi @raneesh_mr ,

Still in the Items of the Procurement Tracker Gallery, formula set as below and I recognized that you would like to count the total number rather than the rows:

AddColumns('Procuremetn Tracker', "TotalNumber", Text(Count(Filter(Workflow, Status.Value = ThisRecord.Status).'Total Count')))

To be clear, you cannot count the total count to the workflow table, it has duplicate and bland Status, it doesn't make sense.

Best regards,
raneesh_mr 55 on 16 Jun 2022 at 12:56:58

Like (0)

Report

Re: Count rows into lookup table

I need status count into workflow because then it show all the workflows including the status not selected in the Procurement Tracker.
It indicate the work load of the department.
v-jefferni on 16 Jun 2022 at 08:15:12

Like (0)

Report

Re: Count rows into lookup table

Hi @raneesh_mr ,

Workflow table has a Status column LookUp from Procurement tracker table, and in the Gallery, items is Procurement tracker table as well. I don't understand why you need to add the total count into workflow table?

BR,
raneesh_mr 55 on 16 Jun 2022 at 08:05:28

Like (0)

Report

Re: Count rows into lookup table

@v-jefferni

I need to count rows value into "WorkFlow" table. In your query adding "TotalNumber" into Procurement tracker.
v-jefferni on 16 Jun 2022 at 05:37:50

Like (0)

Report

Re: Count rows into lookup table

Hi @raneesh_mr ,

Just copy my codes and paste in the formula bar, you have dropped the Text function and added the additional .Value in the end.

Best regards,
raneesh_mr 55 on 16 Jun 2022 at 04:24:18

Like (0)

Report

Re: Count rows into lookup table

Hi @v-jefferni ,

Thanks for your effort.

I'm getting below error.
v-jefferni on 15 Jun 2022 at 06:17:02

Like (0)

Report
Re: Count rows into lookup table

Hi @raneesh_mr ,

OK I understand. For the Gallery, you will need to get respective total number in each line from anther list. So please try below formula in Items of the Gallery:

AddColumns('Procuremetn Tracker', "TotalNumber", Text(CountRows(Filter(Workflow, Status.Value = ThisRecord.Status))))

Then you can set Text of the Label within the Gallery to ThisItem.TotalNumber to display the results.

Best regards,
raneesh_mr 55 on 15 Jun 2022 at 04:14:28

Like (0)

Report

Re: Count rows into lookup table

Hi @v-jefferni ,

I have a SharePoint list (AAA). In AAA one column (Status) is lookup from another SharePoint list (BBB)
In PowerApp I have Gallery and items from BBB. I need to get count of items in AAA in this gallery.

Hope I clarified.
v-jefferni on 15 Jun 2022 at 03:47:07

Like (0)

Report

Re: Count rows into lookup table

Hi @raneesh_mr ,

Could you please share more details about your scenario? Where would you like to display the summed total count?

Best regards,