Help me Help me How to extract value only?

(0) Share

Report

Posted on by minyoungchoe

112

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 ...

Categories:

Building flows

I have the same question (0)

All responses (52)

Answers (1)

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Re: Help me Help me How to extract value only?

Hello @minyoungchoe ,

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

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report

Re: Help me Help me How to extract value only?

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

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Re: Help me Help me How to extract value only?

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

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report

Re: Help me Help me How to extract value only?

Yes it gives me error with

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Re: Help me Help me How to extract value only?

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.

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report

Re: Help me Help me How to extract value only?

Can you help me?

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Re: Help me Help me How to extract value only?

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.

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report

Re: Help me Help me How to extract value only?

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...

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report

Re: Help me Help me How to extract value only?

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Re: Help me Help me How to extract value only?

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.

Was this reply helpful? Yes No