cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Sum all of the values extracted from AI Builder

Hi there,

 

I have this issue with AI builder:

 

I want to sum all columns values from an extracted table from AI Builder. This is a currency field that I'm extracting with € sign so, probably AI builder is extracting it as a string. this table is dynamic meaning that it could have like 2 rows or 11 rows or even more. Can anyone help me with this?

 

Thank you so much for your help!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JoeF-MSFT
Power Apps
Power Apps

Hi @Anonymous - good use case. I was writing the steps to accomplish this, but I realized it's going to be easier if I show them, so here's a video that explains how to accomplish this:

 

2022-07-17_15-14-27.jpg

https://youtu.be/7ZMrorApztc

 

If this is helpful, this might be the start of a career for me as content creator. 😎 Do let us know if something is not clear or have any additional questions.

View solution in original post

4 REPLIES 4
JoeF-MSFT
Power Apps
Power Apps

Hi @Anonymous - good use case. I was writing the steps to accomplish this, but I realized it's going to be easier if I show them, so here's a video that explains how to accomplish this:

 

2022-07-17_15-14-27.jpg

https://youtu.be/7ZMrorApztc

 

If this is helpful, this might be the start of a career for me as content creator. 😎 Do let us know if something is not clear or have any additional questions.

Anonymous
Not applicable

Hi there Joe!!!!

 

Amazing and so helpful tutorial!!!!! thank you so much!!!

 

I'm getting an error:

Cannot process template language expressions in action "Compose_3" inputs in row "0" and column "0": "Template language function "replace" expects the first parameter "string" to be a string. The value provided is of type "Object". See https://aka.ms/logicexpressions#replace for usage details.".

 

I don't know why this is happening because I really did exatcly what it was supposed (I think!)

 

Captura de ecrã 2022-07-18, às 11.36.57 AM.png

 

 

 

 

 

Captura de ecrã 2022-07-18, às 11.39.00 AM.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I'm choosing the AEValueNoVAT AE VAlue to iterate thought and I get the for each with each value in the composer...

 

Thank you very much for your help!!! 

JoeF-MSFT
Power Apps
Power Apps

Hi @Anonymous - happy to hear it's helpful!

 

Is AE Value the name of your column? If so, then you need to select the output AEValueNoVAT AE Value value (yes, with 2 values 🙂)

Anonymous
Not applicable

Joe!!!!! I was able to do it!!!! thank you so much for your help!!!!

Helpful resources

Top Solution Authors
Top Kudoed Authors
Users online (3,906)