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)
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?
I think the problem is, you are adding WDL expressions as regular text. For example...
...is also a expression, so you need to add it following the steps described here:
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
Hope this helps
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:
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!