Working with Array

(0) Share

Report

Posted on by GadiLahav

Hi,

I would like to create an array out of a SharePoint List, which should look like :

Once I will load this into an array, I would need to get data from another list, which holds the ID (but not the Status), in order to get the status from the array.

I am realy having problems with the syntax :

1. If I need to create an arry with those 2 fields (ID and Status) - do I need to use the expression createarray() while initilizing the array? If so - what is the syntax?

2. While perfoming the "For Each" on the SharePoint List for appending the fileds to the array - can I just use "Append to Array" and use [Field1],[Field2], or do I need to use the compose? If so - whay syntax do I need?

3. Last - How do I search the array for a specific ID (let's assume the ID is a variable) and get the status? For example - I have in variable the value "3" Flow 2.PNG Flow 3.PNG and I would like to get "Approved" for it.

Thanks a lot!

Gadi.

All responses (1)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report

Re: Working with Array

Hi @GadiLahav,

I am afraid I don't understand some points you mentioned.

Do you want to get data from the SharePoint List and create an array?

And why do you assume the ID is a variable?

Could you please provide more details about the Flow you want to create?

I did some tests on my side, I don't know if it is what you think.

Create an array value using the value of Select Output. Because it is JSON format, you could use Parse JSON to get the value of ID or Status after creating the array.

Image reference:

For the contents of the Parse JSON schema, you can first output the value of the Select action and follow the screenshot below.

The flow works successfully as below:

Please take a try.

Best Regards,
Barry