In the below function in flow, how do I get the first part of the if statement to basically say, if the result is blank do this...
if( substring(body('Html_to_text'), 0, indexOf(body('Html_to_text'), '---+---')) = null, body('Html_to_text'), substring(body('Html_to_text'), 0, indexOf(body('Html_to_text'), '---+---')))
When I add the = null it errors out - "The expression is invalid"
Solved! Go to Solution.
Hi @TesDA
if(equals(substring(body('Html_to_text'), 0, indexOf(body('Html_to_text'), '---+---')),null),body('Html_to_text'),substring(body('Html_to_text'), 0, indexOf(body('Html_to_text'), '---+---')))
Can you try this expression? (please check the brackets. I might have missed something there)
Basically you have to wrap the condition for '=' in the equals() function.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @TesDA
if(equals(substring(body('Html_to_text'), 0, indexOf(body('Html_to_text'), '---+---')),null),body('Html_to_text'),substring(body('Html_to_text'), 0, indexOf(body('Html_to_text'), '---+---')))
Can you try this expression? (please check the brackets. I might have missed something there)
Basically you have to wrap the condition for '=' in the equals() function.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Worked perfectly! Thank you!
User | Count |
---|---|
87 | |
72 | |
44 | |
26 | |
25 |
User | Count |
---|---|
42 | |
24 | |
23 | |
23 | |
17 |