Unanswered

Get the data form Value

(0) Share

Report

Posted on by Leonwan99

Hi All,

I would like to get the data from the "value" , but the value data has no title for identifying, please help to instruction how to solve it, my flow scheme share as below:

Invoke the data form HTTP.JPG

The scheme explains:

Send an HTTP request to take the excel file form SharePoint and invoke the excel's data from HTTP, finally retrieve the original data form "Value", this way is good for avoiding the SharePoint's versioning setting of "Require to Check out" and don't need to format the excel file to be the table type, also quick and efficiently, but I stuck with the data after invoking from HTTP, please see below link for the data get from "Value" and names it rows:

Invoke data detail.JPG

[

"No",

"CD",

"CAT",

"Sub CAT"

]

[

"Add1",

"Test1",

"format3"

]

[

"Add2",

"Test2",

"format4"

]

The data has no title, I would like to make the rows has a title, just like below content, because I need the title for each of the rows to define each row to apply to the SharePoint list:

[

"No": "2",

"CD": "Add1",

"CAT": "Test1",

"Sub CAT": "format3"

]

[

"No": "3",

"CD": "Add2",

"CAT": "Test3",

"Sub CAT": "format4"

]

I try to use the Select to convert it, but no idea how to get it, cause the "Value" content no title for the formula to quote.

Refer to some article(below link) but their issue has a title and no need to overcome this situation, if you have some idea, please advice, thank you.

https://powerusers.microsoft.com/t5/Building-Flows/How-to-retreive-or-calculate-minimum-and-maximum-values-from/m-p/104169

leonwan99

Categories:

Using connectors

All responses (2)

Answers (0)

Sort by

v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Leonwan99 ,

The array that you provided isn't a valid array, I could see that your flow with action Initialize variable works well, please copy and past the out put of the Initialize variable action, so we could try to make a test on the array and provide a proper workaround for you.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Leonwan99 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-alzhan-msft,

Appreciate for your response and recommend, please refer to the below flow chart and Initialize variable content:

[
[
"Physical properties:",
"2-102",
"2-103",
"2-104",
"2-105",
"2-106",
"2-107",
"2-108"
],
[
"Weight",
".+5%.- 5% ",
".+5%.- 5% ",
".+5%.- 5% ",
".+5%.- 5% ",
".+5%.- 5% ",
".+5%.- 5% ",
".+5%.- 5% "
],
[
"Height",
"25 N",
"35 N",
"45 N",
" 40 N",
" 45 N",
" 45 N",
"12 N"
],
[
"Count",
"25 N",
"35 N",
"45 N",
" 40 N",
" 45 N",
" 45 N",
"12 N"
],
[
"Count1",
"500 N",
"500 N",
"667 N",
" 667 N",
" 667 N",
" 667 N",
" 220 N"
],
[
"Teat AB",
"25 N",
"35 N",
"45 N",
" 40 N",
" 45 N",
" 45 N",
"12 N"
],
[
"Tester ABD",
"25 N",
"35 N",
"45 N",
" 40 N",
" 45 N",
" 45 N",
"12 N"
],
[
"Tester 127632",
"500 N",
"500 N",
"667 N",
" 667 N",
" 667 N",
" 667 N",
" 220 N"
],
[
"ID name 29321",
"500 N",
"500 N",
"667 N",
" 667 N",
" 667 N",
" 667 N",
" 220 N"
]
]

The target is to make it has a title and be chosen in the dynamic content for further application, title model demonstration as below:

[
[
    "Physical properties:":"Weight",
    "2-102":".+5%.- 5% ",
    "2-103":".+5%.- 5% ",
    "2-104":".+5%.- 5% ",
    "2-105":".+5%.- 5% ",
    "2-106":".+5%.- 5% ",
    "2-107":".+5%.- 5% ",
    "2-108":".+5%.- 5% "
],
[
    " Physical properties:":"Height",
    "2-102":"25 N",
    "2-103":"35 N",
    "2-104":"45 N",
    "2-105":" 40 N",
    "2-106":" 45 N",
    "2-107":" 45 N",
    "2-108":"12 N"
],
[
    " Physical properties:":"Count",
    "2-102":"25 N",
    "2-103":"35 N",
    "2-104":"45 N",
    "2-105":" 40 N",
    "2-106":" 45 N",
    "2-107":" 45 N",
    "2-108":"12 N"
]
]

Leonwan99