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?
@Anonymous
Can you share a screenshot from your current flow design?
Thanx!
Proud to be a Flownaut!
Sure!
The text value is correct, i just want work how to get it to pull the value, rather than the text.
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
Proud to be a Flownaut!
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"
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)
User | Count |
---|---|
89 | |
40 | |
22 | |
20 | |
16 |
User | Count |
---|---|
136 | |
54 | |
47 | |
36 | |
25 |