Unanswered

How to promt to auto complete names

(1) Share

Report

Posted on by MSM_Scoozi

I have a flow that gets a string from powerapps that is then converted into an array of values. this is then written to an excel table. there are a total of 432 entries per submission which mean columns 1-432. in the flow I use variables('variablename')[x] where x is the column name - 1. I have tried to have copilot auto name these for me but thought maybe there is a better way to do this. Any help would be appreciated.

Array 0-431 -> measurements read in via a csv/string from powerapps. this is working how I need already.

These map to 1-432 in the excel sheet/table

thank you in advance for any ideas on how this can be done more easily.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MSM_Scoozi

Bit confused on what you are trying to acheieve here- like you are saying about add row to table as well copilot usage here- could not connect both- could you please clarify ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
MSM_Scoozi 63 on at

Like
a
(1)

Report
Copy link

Link copied!

So what I am trying to do is get a string from powerapps like "5.45,3.86,1.24,9.54". This is then converted into an array so that the first number is index 0 and the last number is index 431. These then need to be saved to a row into an excel table using the add row to a table in my flow. Manually typing out the formulas for 432 columns is insane and so I am looking for a way to speed this process up. I cannot get the assistant to do anything meaningful as I am clueless on how to prompt it correctly.

Below is the code I need to be in each of the 432 column inputs in the excel step.
variables('VarName')[index] = variables('VarName')[columnName - 1]

Was this reply helpful? Yes No
MSM_Scoozi 63 on at

Like
a
(1)

Report
Copy link

Link copied!

@Nived_Nambiar here is a short video of what the issue is.

naming these or finding a better way of doing this is my end goal. I have the data where I need it in an array and also have the excel sheet made. as long as the 432 data points can be entered at one time and it works I am open as to how to make that happen. Thanks again!

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MSM_Scoozi

Try like this approach -

Assume i have excel table with these columns

Use get tables to get list of tables

I have created an array which in your case would be result after splitting the data you got from powerapps

Initialize a Json object variable

Now create an apply to each loop which loops as many times as the number of items present in the array variable - in my case it is 4 elements present in array - but your case it would be 432.

see below

Inside the loop do the following actions

Expression -

addProperty(variables('Jobject'),string(items('Apply_to_each')),variables('array1')?[items('Apply_to_each')])

Now use set variable to update the JObject variable.

Outside the loop - do the following

Expression -

first(outputs('Get_tables')?['body/value'])?['id']

Now pass the Jobject variable in row field.

This would work 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Chriddle 8,719 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
I don't like the loop 😉

Select

From

range( 0, length( split( outputs('Compose'), ',' ) ) )

Map (key)

add(item(), 1)

Map (value)

float( split( outputs('Compose'), ',' )[item()] )

Compose 2

first( json( replace( string(body('Select')), '},{', ',' ) ) )

Add a row into a table

Table

first(outputs('Get_tables')?['body/value'])?['id']

Item

outputs('Compose_2')

Was this reply helpful? Yes No