Unanswered

Extracting strings out of object with the same name

(0) Share

Report

Posted on by VolkanEmre

Dear community,

I have the following problem: In my JSON Code I have multiple Objects that contain strings. Each Object has a string with the same designation.

In my case, I want to fill an excel table with the value of each "alias" in the object "reference" (see picture). How can I extract the value out of these strings/objects? When I use the Variable "alias", the string contains only the value of the first object.

Thanks for your help

Bildschirmfoto 2022-12-20 um 14.41.47.png

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

FinderFees 55 on at

Like (0)

Report

Are you trying to do this from a Planner Checklist? I'm asking because it's odd that your "references" are just multiple objects instead of an array of objects.

Getting your response to return an array of references will be what allows you to do what you want, because then you will be able to use ~~an "Apply to Each" loop and specify "references" as the source and "alias" as the property to use for each action~~ the "create CSV table" action that @Kabilesh specified below (I'm not as familiar with using flows to create Excel files, but I still believe it will require you to have an array).

Microsoft suggests that the Action for "Get task details" should be returning an array of references:

https://learn.microsoft.com/en-us/connectors/planner/#gettaskdetails_response

Could it be possible you are using an outdated Action?

Was this reply helpful? Yes No
Kabilesh 177 on at

Like (0)

Report

Hi @VolkanEmre

To Extract value of each column, please assign this one out : item()['ColumnName']

To extract the values into a csv/excel file. Please follow the steps below.

Sample Output

Best Regards,

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