cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dual Super User
Dual Super User

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

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!





If anyone is trying to help you with an issue, the fastest way to say thanks is by kudoing. Be grateful, Thumbs up!

Proud to be a Flownaut!





1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

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

@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!





If anyone is trying to help you with an issue, the fastest way to say thanks is by kudoing. Be grateful, Thumbs up!

Proud to be a Flownaut!





View solution in original post

6 REPLIES 6
Community Support Team
Community Support Team

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

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:16.JPG

The flow works successfully as below:17.JPG

 

 

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

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dual Super User
Dual Super User

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

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!

ExcelFlow.png

 

 





If anyone is trying to help you with an issue, the fastest way to say thanks is by kudoing. Be grateful, Thumbs up!

Proud to be a Flownaut!





valex
Level: Powered On

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

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?

Dual Super User
Dual Super User

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

@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!





If anyone is trying to help you with an issue, the fastest way to say thanks is by kudoing. Be grateful, Thumbs up!

Proud to be a Flownaut!





View solution in original post

Administrator
Administrator

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

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

-Gabriel
Microsoft Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!
Highlighted
letuan930
Level: Powered On

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

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.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,595)