Unanswered

Accessing Array elements

(1) Share

Report

Posted on by Dhiran

143

I have a flow which looks at incomng email from a specific address and creates an array of the subject heading using the Split command. I would like to the 2nd element of the array in the next step to create an calendar event.

If i just place the arrary in the next element I can see the following structure ["Text element 1","Text element 2"]

Is there a way I can get only "Text Element 2" in my next step.

Here is a screen shot of steps

Split Command.png

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

v-xida-msft on at

Like (4)

Report
Hi @Dhiran,
Please take a try with the following workaround:
Add Variables-> Initialize variable action after “Compose” action, Name set to TextArray, Type set to Array, Value set to output of “Compose” action.
In “Create event (V2)” action, type the following formula in Subject parameter:
@variables('TextArray')[1]
Image reference:

The flow works successfully as below:

Best regards,
Kris

Was this reply helpful? Yes No
Dhiran 143 on at

Like (1)

Report

Hi @v-xida-msft (Kris) that worked so thank you. The only issue was the expression would not take the "@" symbol but I could just addd the line without the "@".

Was this reply helpful? Yes No
hasannumanoglu 25 on at

Like (1)

Report

worked perfectly!
Thanks,
Hasan

Was this reply helpful? Yes No
philkky 26 on at

Like (2)

Report
I want to do something similar, I have an array and I was to loop through each entry putting the value in to an HTML table. In this case the formula

@variables('TextArray')[1]

Will keep giving me the same value for the number of items in the array, how do I increment this number or should I take a different approach?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Does anyone know how you would do this (reference an item in array) when there is a variable amount of items. The array is created from a checkbox selection in a Microsoft form and I would want to loop through and create a work item for each instance(item they checked.

Was this reply helpful? Yes No
Dhiran 143 on at

Like (1)

Report

After the array is created, you can get the length of the array and then loop through it.

Was this reply helpful? Yes No
kamotekid 25 on at

Like (0)

Report

Hi! Would you create for me a sample flow?
I'm trying to do the exact same thing, with a variable array based on MS Forms entries. In my flow I've already initialized a variable with the formula length(outputs('FormsQuestion2')) after splitting the string from MS Forms. Next step for me is to update a sharepoint list with each array element, and wondering what the most efficient way is since the length can be variable depending on the Forms response.
Thank you!

Was this reply helpful? Yes No
Dhiran 143 on at

Like (2)

Report

Here is my attempt. If you use a compose statement to split your Question 2 it will provide you with an array. and then use this flow

Was this reply helpful? Yes No
kamotekid 25 on at

Like (2)

Report

Thank you! I adapted your sample above and now I'm able to work through the array with variable lengths.

Was this reply helpful? Yes No
SMarchlik 2 on at

Like (0)

Report

I have a similar but different and (shocking) more complex request. I have a long flow that pulls in JSON Objects and places them into an array, where I will eventually put them into a CSV file to send. However, late in the process I need to update an element of the array:

[
  {
    "Employee Id": "E501815",
    "First Name": "John",
    "Last Name": "Brown",
    "Email": "John.Brown@MyCo.com",
    "Secondary Email": "",
    "Username": "",
    "Password": "",
    "Hire Date": "[Need to insert a date variable value here]",
    "Birth Date": "",
    "Role": "",
    "Country Code": "US",
    "Supervisor Id": "E501090",
    "Group Name": "",
    "Language": "",
    "#Cost Center": "",
    "#Department": "Operations",
    "#City": "",
    "#Supervisor Name": "Ricky Bobby",
    "#Job Title": "Office Manager",
    "#Management Level": "",
    "Supervisor First Name": "",
    "Supervisor Last Name": "",
    "Ship to Full Name": "",
    "Ship to Job Title": "",
    "Ship to Address Line 1": "",
    "Ship to Address Line 2": "",
    "Ship to City": "",
    "Ship to State/Province": "",
    "Ship to Country": "",
    "Ship to Zip/Postal Code": "",
    "Printed Language": ""
  }
]

I've tried everything. Puzzled. Any help would be appreciated!

Was this reply helpful? Yes No