You’re offline. This is a read only version of the page.
Hi,
I have a flow, and we use an Admin Settings table like the below to store email addresses for different email steps in the flow:
so in the Flow I have a Get Items with an ODATA Filter query on the Setting1 column:
then I use a Filter Array step to return just the records where Setting2=Retail Marketing Team Email
After this I want to retrieve the Value1 column that has the string of concatenated email addresses in it, into a variable:
There will only ever be one record in the (filtered) dataset so I want to use a JSON formula like this to populate my string variable:
Share
Reportbody('Filter_array_-_Get_Retail_Marketing_Team_Email')?[0]?['value1']
but the value returned is either empty, or when I try something else I get a flow fail error like this:
Unable to process template language expressions in action 'debug_values' inputs at line '1' and column '2892': 'The template language expression 'body('Filter_array_-_Get_Retail_Marketing_Team_Email')?['Value']?[0]?['value1']' cannot be evaluated because property 'Value' cannot be selected. Array elements can only be selected using an integer index
what am I doing wrong?
Hi @livingstonep,
The reason why the expression did not find the value1 is that the property name is not correct, please pay attention to Uppercase of the "Value1".
Please have a try the following expression:
All responses (
Answers (body('Filter_array_-_Get_Retail_Marketing_Team_Email')[0]?['Value1']
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks for your reply but I get this error:
Unable to process template language expressions in action 'debug_values' inputs at line '1' and column '2893': 'The template language function 'first' expects its parameter be an array or a string. The provided value is of type 'Null'
Try using First function... Something like below in my code...
first(body('Get_items')?['Value'])?['FileID'])
So I guess it might be something like
first(body('Filter_array_-_Get_Retail_Marketing_Team_Email')?['value1'])
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
