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
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
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?
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?
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
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.
Check out this blog post and video I did on this subject: