Unable to trigger the mail action

(0) Share

Report

Posted on by Ramsonthosh17

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....

Categories:

Using flows

I have the same question (0)

All responses (1)

Answers (0)

v-mengmli-msft on at

Like (0)

Report
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.

spilt(triggerBody()?['entity']?['Power BI values'],' ')

Best regards,

Rimmon

Was this reply helpful? Yes No