Answered

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

All responses (3)

Answers (1)

Sort by

fchopo 8,003 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.
sikuness 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jcook ,

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