How to post into an excel table the first item from a AI builder table (with the first row ignored by the AI model)

[Anonymous]

Hi there,

So i have this problem,

I want to add to an excel a float variable coming from an AI builder table. The item is always the first item from the list.

My problem is how do i select the first item and add it to a variable. I've tried lots of solutions but non seams to work correctly.

can anyone help me with this?

thank you very much for your help!

[JoeF-MSFT · Accepted solution]

Hi @Anonymous - great to see that you keep building your automation! 🙂

I'm adding an animation below so you can see how to do it. Basically:

1. Add a Compose action to your flow and add the field {name of your table} entries

2. Add an Initialize variable action, and add the following expression: first(outputs('Compose'))?['{Replace by the name of your column}/value']

💡 Something to keep in mind, these steps above will extract that first value as a text. To transform it to a number, you will need to the steps we looked at last week in the other forum post: Solved: Re: Sum all of the values extracted from AI Builde... - Power Platform Community (microsoft.com) Instead of an Initialize variable in step #2, you will need to add a Compose action instead, and do the conversion as we saw in the linked forum post. 

I hope this helps you get a step closer achieving the automation you're working on! 

[Anonymous]

Hi there Joe!!!

Thank you very much for your help!!!

I have this things happening, I don't see in my variable list the string type...that is really odd!

Thank you so much for your help!!!!

Yes, I just need after this to be able to copy (from an excel where I'm pasting this converted values) and paste some cells in a specific place of an excel. I'll have to seacrh if there any info on that after this phase is done!!!!

Thank you so much for your amazing help!

[JoeF-MSFT]

Hi @Anonymous !

I have this things happening, I don't see in my variable list the string type...that is really odd!

Ah, interesting! What options do you see? Can you share a screenshot?

[Anonymous]

 

Yes, it's very strange indeed, sorry for the language, but basically i can see all except the String one...

[JoeF-MSFT]

Ah! I think it's Cadeia in Portuguese. It's the literal translation of a string. Maybe texto is a better translation that we should put? 😅

[Anonymous]

sorry my delay on the reply,

yeah, definitely the name should be texto and not cadeia, it doesn't make any sense!

But everytime I'm select compose and add the name of the table/the column that i want to add (example: consumptionTable kWh) it automatically puts the compose in a loop but in your video it doesn't do that...Am I doing something wrong here?

[JoeF-MSFT]

Hi @Anonymous - good to know that texto should be the right way to say it 😅

I'd suggest looking again at the animation from my first message on the top. Notice that first I select  {name of your table} entries , and then I write the column name in the next step as an expression. I don't select the column name from the list of fields returned by the AI Builder model.

Let me know if it's still not clear. 🙂

[Anonymous]

thank you so much for your help!!!! I didn't knew about this [NAME OF THE TABLE] Entries variable then i found it and everything was more clear and easy! thank you so much for your help!!!!