cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Chow
Level: Power Up

Excel Insert Row is looking for a deleted Manual Trigger Input Text and causing Flow error

I am setting up a Flow to track working hours and locations, initally added 5 Manual Trigger Input Text to capture users' input and then deleted one of them (Text_4) from input list. When I run the Flow it should capture all my inputted texts, timestamp and location, follow by Excel Insert Row to fill in my Excel. Here comes the issue, Flow prompted me with error below at Insert Row step when i am trying to run the Flow:

"Unable to process template language expressions in action 'Insert_row' inputs at line '1' and column '1683': 'The template language expression 'triggerBody()['text_4']' cannot be evaluated because property 'text_4' doesn't exist, available properties are 'user, key-button-timestamp, key-button-date, location, text, text_1, text_2, text_3'. Please see https://aka.ms/logicexpressions for usage details.'."

 

Seems like Excel Insert Row function still looking for Text_4 although I already deleted it. Can anyone help me with this error?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Excel Insert Row is looking for a deleted Manual Trigger Input Text and causing Flow error

Hi @Chow,

 

Could you please share a screenshot of the configuration of your flow?

Could you please share more details about your scenes?

Have you use the expression 'triggerBody()['text_4']' in your flow to insert row to excels?

 

If you have deleted the Input Text from the Manual Trigger, you couldn't use the expression 'triggerBody()['text_4']'.

 

I have made a test on my side to create a flow as below:

Capture.PNG

 

The flow would run failed as you as below:

Capture.PNG

 

Please make sure you haven't use the expression of a not exist Input Text of Manual Trigger in your flow.

Also could take a try to create a new flow to achieve your needs.

 

 

Please let me know if your problem could be solved.

 

Best regards,

Alice

3 REPLIES 3
Community Support Team
Community Support Team

Re: Excel Insert Row is looking for a deleted Manual Trigger Input Text and causing Flow error

Hi @Chow,

 

Could you please share a screenshot of the configuration of your flow?

Could you please share more details about your scenes?

Have you use the expression 'triggerBody()['text_4']' in your flow to insert row to excels?

 

If you have deleted the Input Text from the Manual Trigger, you couldn't use the expression 'triggerBody()['text_4']'.

 

I have made a test on my side to create a flow as below:

Capture.PNG

 

The flow would run failed as you as below:

Capture.PNG

 

Please make sure you haven't use the expression of a not exist Input Text of Manual Trigger in your flow.

Also could take a try to create a new flow to achieve your needs.

 

 

Please let me know if your problem could be solved.

 

Best regards,

Alice

Administrator
Administrator

Re: Excel Insert Row is looking for a deleted Manual Trigger Input Text and causing Flow error

Hello, @Chow  !

 

Have you had a chance to apply  @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

 

Thank you for being an active member of the Flow Community!

 

-Gabriel

Flow Community Manager

-Gabriel
Microsoft Flow Community Manager
Chow
Level: Power Up

Re: Excel Insert Row is looking for a deleted Manual Trigger Input Text and causing Flow error

Hi @v-yuazh-msft,

 

Thanks for your promptly response and help!

 

In my initial flow that having this issue, i didn't use 'triggerBody()['text_4']' at all, but still it gave me this error after deleting the Input Text 4. Then I deleted the flow and created a new 1, and this time i make sure adding only number of Input Text required and no more error. So i am unable to provide you a screen shot of my previous flow that was having issue, my bad.

 

Mins ago i created another new Test Flow same setting with the previous flow with issue just to verify again on this incident, which i added Input Text 4 and then deleted it again, and do not use Input Text 4 at all in the whole flow, surpringly this time round the flow has no error.

 

Thanks for your help, i will accept this solution and keep monitoring, will reach out to you for help if i encounter the same issue again, cheers Smiley Happy

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 500 members 4,325 guests
Please welcome our newest community members: