Excel Online (Business) - Add a row into a table

[efialttes]

I have an excel file stored on a Sharepoint from an Office 365 group, trying to add a new row to the only table I have defined inside.

Currently Flow editor displays three connectors when searching for "Excel":

-Excel: this connector points to OneDrive4Business only

-Excel Online (Business) - Preview: this connector allows me to select different sources, including Sharepoint sites and the Sharepoint from Office 365 groups 

-Excel Online (OneDrive): looks like it points to OneDrive only.

So, I chose to use the following Action Block: Excel Online (Business) - Add a row into a table

After adding this action block, I have reviewed more carefully the options available when defining the Source, the help message is as follows:

Select from the drop-down or specify one of the following:

-"me"

-"sharepoint site URL"

-"users/someone's UPN"

-"groups/group Id"

-"sites/SharePoint Site URL:/teams/team name/:" (colons are required)

Then I select from the Source drop-down menu the target Office 365 group (please note I do not have to type it explicitly). Once I select the proper Drive, File (navigating through the Office 365 group sharepoint directories, again I did not have to type it explicitly) and the Table name, the column names to be filled are displeyed by the Editor. So far so good:

These are the inputs I have chosen

Source	Group - AT4_Apps_Spain
Drive	Documents
File	/Datos adjuntos de correo electrónico/probando inventario juegos.xlsx
Table	Tabla1
Fabricante	variables('Preload')?['OEM']
Modelo	variables('Preload')?['Model']
Juegos	variables('Games2PreloadString')

I assign values to Fabricante, Modelo & Juegos from previous flow steps.

However, when executing the flow the following error is displayed:

Unable to process template language expressions in action 'Add_a_row_into_a_table' inputs at line '1' and column '2393': '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 'shared_sharepointonline, shared_office365'. Please see https://aka.ms/logicexpressions for usage details.'.

Suggestions are welcome!

[v-xida-msft]

Hi @efialttes,

Could you please share a screenshot of your flow's configuration?

The error message seems to tell that there is something wrong with the connection to the "Add a row into a table" action within your flow. I have made a test on my side and don't have the issue that you mentioned. My flow's configuration as below:

The flow works successfully as below:

Please check if the connection to your "Add a row into a table" action is invalid, if yes, please update the connection to the action and then try your flow again. In addition, you could also re-create a new connection to this action and then try your flow again to check if the issue is solved.

The user @Russel_Thomas has faced similar issue with you and the user @paulculmsee has made a response to it. Please check the following thread for more details:

https://powerusers.microsoft.com/t5/General-Discussion/flow-launched-from-powerapps-error/td-p/43399

Best regards,

Kris

[efialttes]

Thanks for your fast and detailed response, Kris @v-xida-msft!

I've created a new connection, the problem persist.

So, instead of playing with the old flow, I've created a more simple flow from Sharepoint by selecting the Template "Complete a custom action for the selected item”, with just three steps:

1.-Sharepoint Trigger - For a selected item

Default values

2.-Sharepoint Action - Get item

Default values

3.-Excel Online (Business) Action - Add a row into a table

Now it works! I mean the row is inserted on the excel table, no error message displayed.

So I keep on adding the rest of the action blocks from my original flow one by one and testing afterwards. As a 4th step I add "Office 365 Send an email".

Once I add it and test it, the same error is displayed, but in this case referring to "Office 365 Action- Send an email":

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

So, it looks if I combine step 3-"Add a row into a table" and step 4. "Office 365 Action- Send an email" in the same flow, the second block added fails. In my first and more complex flow, I added first "Send an email", updated the flow, then added "Excel Online (Business) Action - Add a row into a table" and it failed. In the second, more simple flow I did the opposite.

Can you try to reproduce it?

Thank you in advance!

[valex]

I guess the main problem is with the "Preview" statement in the title of the action. I was trying to use the same thing for the purpose of refreshing the query in one Excel worksheet located on my SharePoint Online, and it is doing practically nothing at all.

Therefore, this is a question for Flow development team @Microsoft - when is this action going to be enabled?

[efialttes · Accepted solution]

@valex

Thanks for sharing your experience!

As a workaround I implemented both action blocks in different flows, and then from the first flow I invoke the second one. This way it worked fine.

Hope it helps!

[GabrielStJohn]

Hey, @efialttes!

Thank you for posting to the Flow Community Forum! It appears you have found a solution to your issue! If you feel as though your issue has been solved and you are satisfied with one of the previous replies, please click "Accept as Solution" on the reply that contains the 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
Microsoft Flow Community Manager

[letuan930]

thank you for your sharing.

I am using O365 package. When i search "excel", it shows only the "Excel Online (business)" and "Excel Online (Onedrive)" not showing ""Excel". Thus I can select "Get Row" only instead of "Excel-Get Rows"

Please help to advise.