AI Text Classification Model works but output written to Excel is incomplete

(0) Share

Report

Posted on by JN-31101254-0

I've created a Text Classification Model that can output more than one tag, and I want to incorporate a Power Automate flow that, periodically:

1. Lists all items in an excel file,

2. Filters by items added last week,

3. Runs a text input through the AI Model and

4. Writes the output in a separate column in the same excel file.

When I select the the column to output and write:

outputs('Predict')?['body/responsev2/predictionOutput/results']
 
The written output in Excel is, for example, "[{"@odata.type":"#Microsoft.Dynamics.CRM.expando","type":"Economics","score":0.99856824},"@odata.type":"#Microsoft.Dynamics.CRM.expando","type":"Technology","score":0.7865113}]", 
 
yet, if I select the Dynamic Content "Type" items('For_each_1')?['type'], the written output is only "Economics". 
 
I want the output to be "Economics, Technology", how can I make sure that happens?

Categories:

AI Builder

Captura de ecrã 2...

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Michael E. Gernaey 51,803 Super User 2025 Season 2 on at

Like (1)

Report

AI Text Classification Model works but output written to Excel is incomplete

Hi @JN-31101254-0

The easiest way is to create an Apply to each and have an array variable, where you add in the type property to the array as it loops, or a string variable will work and use Append to Array, or Append to String. I like array better, as then I just use a join(arrayname, ',') in your output to excel and you get the comma separated list

The issue is its an array and you need to grab them all hence the loop.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

1 people found this reply helpful.

Was this reply helpful? Yes No