Flow fails when field is blank.

(0) Share

Report

Posted on by anthonys123

457

The error I get is

Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2877': 'The template language expression 'triggerBody()['text_6']' cannot be evaluated because property 'text_6' doesn't exist, available properties are 'text, text_1, text_2, text_3, boolean, boolean_1'.

I've tried the following formula, found here, but it's not working.

if(empty(outputs('Compose')),null,outputs('Compose'))

The result should be that this value is entered in an excel sheet. There are plenty of other fields in this flow that don't cause a problem when left blank. It's only when I add this item and leave it blank that an issue occurs.

Screen Shot 2021-01-07 at 1.52.54 PM.png Screen Shot 2021-01-07 at 1.54.34 PM.png

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

v-litu-msft on at

Like (0)

Report

Hi @anthonys123,

You could set the Configure run after in the following action setting to make sure when the Sales/PM field is empty Flow could run continue.

If the Compose action runs successfully, go to branch that adds the Sale/PM into the Excel;

If the Compose action runs failed, go to branch that adds the empty value into the Excel.

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.

Was this reply helpful? Yes No
anthonys123 457 on at

Like (0)

Report

Thanks. While I figure out how to make this overly complex workaround work, is there a reason why I only need to do this for just one of my fields? I have 14 other fields that don't result in an error if left blank.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @anthonys123,

I'm just giving an example of how this method can be used. If there are fourteen other such fields to judge, I'm afraid you'll have to repeat the structure mentioned in my previous reply fourteen times.

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.

Was this reply helpful? Yes No
anthonys123 457 on at

Like (0)

Report

You're saying I need to repeat this for fields that are working? Not only do I have 14 fields that are working, I have this flow repeating 6 times for each branch of our office. So, that would be 84 time consuming bandaids for something that should work out of the box.

Was this reply helpful? Yes No
Verified answer

anthonys123 457 on at

Like (1)

Report

@v-litu-msft I think I'm just going to send these values to a SharePoint List instead of Excel. Hopefully the boss is okay with that. I can't spend a week applying and testing bandaids for these simple flows.

Was this reply helpful? Yes No
v-litu-msft on at

Like (1)

Report

Hi @anthonys123,

SharePoint is a wise choice.

Best Regards,
Community Support Team _ Lin Tu

Was this reply helpful? Yes No