04-16-2025 01:23 AM - edited 04-16-2025 01:24 AM
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.
04-16-2025 02:06 AM
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.
04-16-2025 02:06 AM
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.
a month ago
Thanks @Bhagya_pola, yes that worked.
04-16-2025 11:37 AM
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.
a month ago
Thanks @gary1 , yes I needed to change to lower case