Power Platform Community Forum Thread Details

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.

Categories:

Building flows

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: