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

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!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

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!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

6 REPLIES 6
Highlighted
Community Support
Community Support

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.
Highlighted
Dual Super User III
Dual Super User III

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

 

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper I
Helper I

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?

Highlighted
Dual Super User III
Dual Super User III

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!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Highlighted
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
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager
Power Platform Communities
Highlighted
Regular Visitor

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
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (7,497)