Sum a column consolidating various results

(0) Share

Report

Posted on by fgonzalez515

296

Hello Community,

I have a Sharepoint Odata and I want to sum a column, but I want the result or Compose to be by type or classified, as in the example.

The problem that my flow adds everything, obtaining only one result and not three as in the example.

Consider that in the future more elements of the column "Recurso" can be added.

This is my flow

I request help from the community

I have the same question (0)

All responses (11)

Answers (1)

v-bofeng-msft on at

Like (0)

Report

Re: Sum a column consolidating various results

Hi @fgonzalez515 :

I've made a test for your reference:

1\My SP list

2\My Flow:

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No
Paulie78 8,418 Moderator on at

Like (1)

Report

Re: Sum a column consolidating various results

Check out this blog post and video I did on this subject:

How to sum a SharePoint column

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Re: Sum a column consolidating various results

Hi @v-bofeng-msft

I followed the proposed flow, but I threw this error.

My Flow is this

For the flow, use the columns of my Odata Sharepoint.

Please if you help me with that.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Re: Sum a column consolidating various results

Hi @fgonzalez515 :

Please call the correct filed name

You could try:

IDObra

or

Obra

Or another way of thinking, modify your data source, remove the space in the field name. In many cases, field names with spaces are inconvenient.

Best Regards,

Bof

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Re: Sum a column consolidating various results

Hi @v-bofeng-msft

I found that I was missing a sign for the flow to run, was it the sign?

But I can't get the expected result.

That could be happening?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Re: Sum a column consolidating various results

Hi @fgonzalez515 :

Best Regards,

Bof

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Re: Sum a column consolidating various results

Hi @v-bofeng-msft,

Thanks, i understood my mistake and it was fixed.
The form of the result is as expected, but I have a problem with the number of items that are considered for the flow. The flow takes fewer items.
For example for the 'Obra': 29 the items to consider are 287, but the flow takes 22 items.

What could have happened?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Re: Sum a column consolidating various results

Hi @fgonzalez515 ：

Please try:

Hope this link hepls:

256 rows limit

Best Regards,

Bof

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Re: Sum a column consolidating various results

Hi @v-bofeng-msft,

That's right, I had it configured in the beginning.

What can be?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: Sum a column consolidating various results

Hi @fgonzalez515 :

Please check the number of items returned by "get items" action.

Did you use Filter Query in your "get items" action?

Best Regards,

Bof

Was this reply helpful? Yes No