Help me Help me How to extract value only?

[minyoungchoe]

The one I want to extract is 'Value' of Analytical Categories.

which looks like below.

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":3,"Value":"Statistical/Forecasting"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":4,"Value":"Insights/Descriptive"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":10,"Value":"Classification"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":5,"Value":"Machine Learning/Predictive"}]

It never every gives me dynamic value so I already tried to use expression item()?['Analytical Categories']?['Value']

It returns null only.

Please help me ...

[Matthy79]

Hello @minyoungchoe ,

Use a select action and switch to text mode. From is the dynamic value of your screenshot and map is „item()['Value']“.

[minyoungchoe]

It does not select action in the create csv action. Would you help me? I never forget your help... I really want to go home

[Matthy79]

Have you tried „item()['Value']“?

[minyoungchoe]

Yes it gives me error with 

[Matthy79]

The error message is clear. There is no property with the name „Value“, so the array you posted is not the array you selected in the csv action.

[minyoungchoe]

Can you help me?

[Matthy79]

If you create a csv table you have to provide an array that you want to convert to csv.

The array you provided in your opening post is not the array you are using to create the csv.

Add a compose action before the create csv action and put in the value you are trying to use to create the csv. After that run the flow and check the flow run history of this new compose action.

[minyoungchoe]

Once I try to do what you are saying,
It makes apply to each action then put the compose(select) to the loop and then in the csv action, I am not able to use the output from apply to each.
I really appreciate your time...

[minyoungchoe]

[Matthy79]

Are you 100% sure that you use the same dynamic content in the compose action that you use in from in the csv action. I don’t think so.

[minyoungchoe]

Yes I am sure.

[minyoungchoe]

[Matthy79]

As you can see on the screenshot, you didn’t use a compose action but you use a select action. You also not use the value you used in the csv action but you used a property that is inside the value. That is why it created an apply to each. So please delete that apply to each, add a compose action and put in the same value as you did in the csv action.

[minyoungchoe]

Okay, I put value as you explained as below.
Would you give me some hint how can I use specific value from compose?

[Matthy79]

Have you run the flow and have you checked the flow run history for that new compose action? What does the output look like? I don’t think you find a property with the name “Value”, do you?

[minyoungchoe]

YES... I found value. Please see highlighted part.

[minyoungchoe]

I need to use the 'Value' of AnalyticalCategories

[Matthy79]

But this is not directly a property of the value you are selecting. I don’t see the whole data but it looks like it is part of an array inside that array. So what exactly should the csv table look like because it seems that there could be multiple values for each row.

[minyoungchoe]

Sorry is there any way that I can share my screen?
I really want to solve the problem