cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jbelo
Frequent Visitor

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 @Jbelo - 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 @Jbelo - 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.

Jbelo
Frequent Visitor

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 @Jbelo - 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 🙂)

Jbelo
Frequent Visitor

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Top Solution Authors
Top Kudoed Authors
Users online (4,902)