Unanswered

data from sharepoint is a nested array

(0) Share

Report

Posted on by dperez13

432

how do i grab my sharepoint list items that are in a nested array? its a multi choice field, comma separated in the spo list, but looks like so in the odata?

my flow is a get items -> appy to each (outputs (GET ITEMS)[body/value] -> compose

{

"@odata.type" : " stuff"
"ID":-1

"Value": "what i want"

{

"@odata.type" : " stuff"
"ID":-1

"Value": "ALSO what i want"

}

how do i get these values? i need them displayed in a custom html table but id be happy just to know how to extract each one.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

dperez13 432 on at

Like (0)

Report

also im not sure if this is an array or an object. i tried to 'parse json' , not sure if thats necessary, but it told me my data is an object and not an array

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@dperez13

I suspect that you can just reference the Value from Dynamic properties - such as Stuff Value.

You will be in a loop when you refernce the column.

If tyhat isn't what you need, please let me know.

Was this reply helpful? Yes No
dperez13 432 on at

Like (0)

Report

it always puts in a 2nd apply to each when i try to grab another dynamic property.
trying to grab the value throws me into an apply to each where it gives me an array where value is just one of the fields

its almost as if i need body/value/VALUE

its because the data comes in as a table i think from power apps..

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@dperez13

Can you post a screen shot of your Flow?

Also, can you confirm that the column is a multi-select option column?

Was this reply helpful? Yes No
dperez13 432 on at

Like (0)

Report

parsing the json allowed me to grab just the value, so i have two values in an array id imagine, but i need to do this for many , many columns. can i combine all their outputs in a single parse json?

Was this reply helpful? Yes No