Hi guys ,
I am currently doing my project using power automate to automate my email flows , While running i got this error " The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@{triggerBody()?['entity']?['Power BI values']} ' is of type 'String'. The result must be a valid array." How can convert this to array expression should be like this "@triggerBody()?['entity']??{}['Power BI values']" two question mark.
help me guys..
..
Hi @Ramsonthosh17 ,
Could you please show the outputs of '@{triggerBody()?['entity']?['Power BI values']} ' ?
If the expression output string is separated by a certain character, such as a space, you can use the spilt function to cut it into an array.
Share
Report
All responses (
Answers (
spilt(triggerBody()?['entity']?['Power BI values'],' ')
Best regards,
Rimmon
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,026
Most Valuable Professional
