Unanswered

Error with flow while using "Add a new Row in Table"

(0) Share

Report

Posted on by sikuness

Hi Guys/Gals,

Long time lurker, but posting for the first time. I am a complete amateur when it comes to Power Automate/Apps, but this website has been a huge help. I have been having trouble with my new flow, where it is pulling data from Power Apps.

I am using initialize variable function (string) to create various variables, and using the set function in Power Apps to assign value to them. This works perfectly and the data is being read by P. Automate but when I try add a new row in excel using the variables as the values, I get the following error:

Quote

Unable to process template language expressions in action 'Add_a_row_into_a_table' inputs at line '1' and column '2270': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_excelonlinebusiness']['connectionId']' cannot be evaluated because property 'shared_excelonlinebusiness' doesn't exist, available properties are ''. Please see https://aka.ms/logicexpressions for usage details.'.

Unquote

This is a picture of how my flow is setup:

This is the run history screen:

Thanks in advance for your help everyone. Cheers!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

fchopo 8,003 Moderator on at

Like (0)

Report

Re: Error with flow while using "Add a new Row in Table"

Hello @sikuness
Instead of testing the flow with previous executions, trigger the flow manually or perform the action that triggers it.
Hope it helps
Ferran

Was this reply helpful? Yes No
Verified answer

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Re: Error with flow while using "Add a new Row in Table"

Hello @sikuness

Please try @fchopo suggestion.

if that does not work.

Check to make sure your Power App has been published.

If it has you will have to remove the flow from Power Apps and re add.

When using Power Apps trigger. The connections that get used when the flow is triggered are pulled from the person inside the Power App.

Doing the above steps will ask for the users access to use their excel connection when opening the app for the first time after it’s been published.

Was this reply helpful? Yes No
sikuness 20 on at

Like (0)

Report

Re: Error with flow while using "Add a new Row in Table"

Hi @Jcook ,

I tried what you suggested, and it worked. Thanks for the help.

Was this reply helpful? Yes No