Unanswered

How to insert Sharepoints items to Array?

Like (0) Share

Report

Posted on 29 Feb 2020 11:59:02 by ywliang96

I have a column of Sharepoint items where I want to insert it into Array in Flow for comparison purposes. How can I put a chosen column to an array?

I have the same question (0)

All responses (11)

Answers (0)

v-litu-msft on 06 Mar 2020 at 09:14:02

Like (0)

Report

Re: How to insert Sharepoints items to Array?

Hi @ywliang96,

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Was this reply helpful? Yes No
v-litu-msft on 02 Mar 2020 at 06:38:52

Like (3)

Report

Re: How to insert Sharepoints items to Array?

Hi @ywliang96,

The screenshot shows that the output of the Append to array variable action. Actually, you could create a compose action, then put the variable into it to check it.

Also, you could use the Select action to approach it:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
efialttes 14,756 on 02 Mar 2020 at 06:26:34

Like (0)

Report

Re: How to insert Sharepoints items to Array?

Hi
Seems you are inspecting the variable value in the first iteration.
My suggestion is: append a Compose action block outside Apply to Each, at the bottom of your flow, add your variable as its Input. Reexecute the flow and inspect the content of the Compose
Hope this helps

Was this reply helpful? Yes No
sudharsan1985 1,325 on 02 Mar 2020 at 03:50:46

Like (0)

Report

Re: How to insert Sharepoints items to Array?

Hi @ywliang96
can you please send the 'Apply to each' of the flow already ran like the below. You can see the 'Next' link which will navigate through each output from the 'Get Items' action.

Hope it helps, please like or mark it as a solution if it resolves your issue
-Sudharsan K...

Was this reply helpful? Yes No
sudharsan1985 1,325 on 02 Mar 2020 at 01:59:56

Like (0)

Report

Re: How to insert Sharepoints items to Array?

Hi @ywliang96
Can you please post the 'Apply to each' action for the successfully ran flow like the below. There is a 'Next' link which will navigate to each items. Try to use the array collection after the 'Apply to each'.

Hope it helps, please mark it as answered if it resolves your issue.
-Sudharsan K...

Was this reply helpful? Yes No
ywliang96 38 on 02 Mar 2020 at 01:38:04

Like (0)

Report

Re: How to insert Sharepoints items to Array?

Here is my record in the column in Sharepoint List that I'm looking to extract to arrays. I have about 21 records

Here is the Flow that I created which follows exactly as what is shown on top.

Here is the output from Get Item. Noticed that I search my To/From column and it actually brings 21 record.

Here is the Append Array Output which only brings 1 record instead of the 21 records. What am I missing?

Was this reply helpful? Yes No
abm abm 32,506 Most Valuable Professional on 01 Mar 2020 at 21:45:31

Like (1)

Report

Re: How to insert Sharepoints items to Array?

Hi @ywliang96

Make sure you are using Get Items SharePoint action step. Also check you have more than one records in SharePoint. Are you using any specific filters in Get Items. If so make sure your filter is correct and expect more than one records for the specified filter.

Check your flow run history and expand the Get Items Step output. Here you can see how many records you are getting.

Thanks

Was this reply helpful? Yes No
sudharsan1985 1,325 on 01 Mar 2020 at 10:36:00

Like (0)

Report

Re: How to insert Sharepoints items to Array?

Hi @ywliang96
Please look at the screenshot below. For verification, I had assigned another variable and concatenated the final array to a comma-separated string. Try to click the 'Next' button in the 'Apply to each' branch.
If you still have some clarifications, please share your flow so that it will be clear for us to understand.

Please mark it as answered if it resolves your issue.
-Sudharsan K...

Was this reply helpful? Yes No
ywliang96 38 on 01 Mar 2020 at 08:08:16

Like (0)

Report

Re: How to insert Sharepoints items to Array?

I only able to get 1 record stored in the Array.

For example, the column "Title" has

Title1
Title2
..
Title100

But using your way, I only able to get 1 record.

Was this reply helpful? Yes No
sudharsan1985 1,325 on 01 Mar 2020 at 03:51:17

Like (2)

Report

Re: How to insert Sharepoints items to Array?

Hi,
If i understood you correctly, you are trying to add a particular column value from all the items to an array for future comparison purposes. I got all the items and particularly I am adding all the 'Title' field values to an array called 'ItemCollection' which is initialized before getting the items.
Please mark it as a solution or answered if it resolves your issue.
Regards
Sudharsan K...

Was this reply helpful? Yes No