Unanswered

Error while trying to get mail body to excel

(0) Share

Report

Posted on by erezyash

Hi,

I'm trying to write an expression that will extract the value of the 23.24M (it's a variable and can be changed) in the following sentence and add it to an excel sheet -

"Bandwidth Limit Exceeded: Your current bandwidth usage has reached 23.24M, surpassing your contract limit of 20M."

I've created the following expression - trim(split(split(variables('inputSentence'), 'has reached ')[1], ',')[0])

But I got the following error -

Flow save failed with code 'InvalidVariableOperation' and message 'The inputs of workflow run action 'Add_a_row_into_a_table' of type 'OpenApiConnection' are not valid. The variable 'inputSentence' must be initialized before it can be used inside action 'Add_a_row_into_a_table'.'.

Any idea why? Any help?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@erezyash As per the error, Pls initialize your variable which you have used in the expression.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@erezyash As per the error, Pls initialize your variable which you have used in the expression.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
erezyash 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks.
What does it mean "The variable 'inputSentence' must be initialized"? how can I do it?

Was this reply helpful? Yes No