2 weeks ago - last edited 2 weeks ago
I'm trying to reference the ID property of a list item in a data pill expression. I could do a for each and loop through to get the relevant item, but I guess there must be a way to do this via the expression.
This expression gives me an error when I try to test the recipe.
Solved! Go to Solution.
2 weeks ago
Hello @Waldy
you can give it a try using pluck formula
for example:
This is my json:
In the above json I'm trying to fetch the first person age using the name, here how I am doing it
Since I'm trying to fetch age from matching person which is Jhon and, I am using indexing to get first value in case of multiple records.
Once go through and modify this formula according to your requirement.
2 weeks ago
Hello @Waldy
you can give it a try using pluck formula
for example:
This is my json:
In the above json I'm trying to fetch the first person age using the name, here how I am doing it
Since I'm trying to fetch age from matching person which is Jhon and, I am using indexing to get first value in case of multiple records.
Once go through and modify this formula according to your requirement.
2 weeks ago
Thanks @Bhagya_pola, yes that worked.
2 weeks ago
The label of the data pill is often not the "API Name" which is the key need to you use in the expression. Hover over the data pill and you can see the API Name. It might just be a casing thing, like "Name" versus "name", or it might be something entirely different.
2 weeks ago
Thanks @gary1 , yes I needed to change to lower case