Get variable column data from sharepoint, using column name from flow.

[Anonymous]

Ok, so this is probably something unbelievably stupid that I'm missing, but I'm drawing a blank, and 3 hours of googlefoo is failing me

I have a SharePoint list with columns for various countries, and i want to create a dynamic lookup so given a country from the triggerbody i can get a specific value from the relevant SharePoint column.

Something like this.

Get item from sharepoint (works perfectly - filtered by *ITEM*)

Apply to each item (works perfectly)

items('Apply_to_each')?['*COUNTRY*']

But I can't get either set/initialize variables or Compose to show the correct output, they all show the text "items('Apply_to_each')?['*COUNTRY*']" rather than the value.

Am i missing something painfully obvious?

[efialttes]

@Anonymous 

Can you share a screenshot from your current flow design?

Thanx!

[Anonymous]

Sure!

[Anonymous]

The text value is correct, i just want work how to get it to pull the value, rather than the text.

[efialttes]

Hi!

I think the problem is, you are adding WDL expressions as regular text. For example...

items('Apply_to_each')?['China']

...is also a expression, so you need to add it following the steps described here:

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

Can you please also share your trim() based WDL expression and explain briefly what you wanna calculate with such expression?

On the screenshots share I cannot see its details

Thanx!

Hope this helps

[Anonymous]

well yes, that's the problem, I don't want the text, I want the expression.

The trim is a horrendous thing, but it pulls out the country required. it pulls out the country name from the trigger body. in the example i posted earlier, it was "China"

trim(substring(triggerBody()?['po_configurationdetails'],add(indexOf(triggerBody()?['po_configurationdetails'],'TEXT 24 chars long'),24),sub(indexOf(triggerBody()?['po_configurationdetails'],'MORE TEXT'),add(indexOf(triggerBody()?['po_configurationdetails'],'TEXT 24 chars long'),24))))

What i want to do then is using a "get items" from a SharePoint site get the value from the column named "China"

[LearnDevil]

If you happen upon here, this may be what you are after:

Identify which SharePoint item columns were updated in Power Automate (tomriha.com)

Get previous value(s) of modified SharePoint column(s) in Power Automate (tomriha.com)