cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Chris1806
Level: Power Up

SAP to Excel upload tasks

I would like to create a flow that takes a list from Excel and uploads it to SAP.   Is this possible with MS-Flow? 

 

Example: 

1.   Excel sheet is populated

2.   MS-Flow Opens SAP and login prompted

3.   T-Code entered by MS flow

4.   MS-Flow pulls the data from the excel sheet, enters it into SAP, and Executes (press F8)

5.   MS-Flow pulls the next line and continues until error or skips error and continues to completion. 

6.   Returns list of errors.

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: SAP to Excel upload tasks

Hi @Chris1806 ,

 

Could you please explain more details about the error that you mentioned?

Microsoft flow could get rows from a existing excel table and save the rows to a sharepoint list currently, if you want to get rows from a existing excel table and save the rows to a sharepoint list, you could take a try with Microsoft flow.

 

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

abhicn
Level: Powered On

Re: SAP to Excel upload tasks

Hi,

This can be achieved using UI flow. Please find the screenshot of the flow I currently use.

 

image2.pngEXCEL list to SAP

View solution in original post

6 REPLIES 6
Community Support Team
Community Support Team

Re: SAP to Excel upload tasks

Hi @Chris1806 ,

 

Could you please explain more details about the error that you mentioned?

Microsoft flow could get rows from a existing excel table and save the rows to a sharepoint list currently, if you want to get rows from a existing excel table and save the rows to a sharepoint list, you could take a try with Microsoft flow.

 

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Chris1806
Level: Power Up

Re: SAP to Excel upload tasks

Correct Flow can pull from Excel. 

Can MS-Flow paste into SAP Fields and run run procedural, resume on error, or pause on error.  

 

For Example:   I can do this right now using SAP-GUI scripting wrapped in W32 shell.   Take an excel sheet of data,  and paste into SAP, and run until complete.  It can also be done with Python, or PowerShell.  

 

I want to know if I can do this with MS-Flow?  take an excel sheet and paste the cells of the excel, into the fields in the SAP GUI and run until complete or action based on error. 

 

EXAMPLE 2:   Can MS-FLOW take from an excel sheet and paste into web page fields.  then execute until the excel sheet is complete or an error takes place. 

Community Support Team
Community Support Team

Re: SAP to Excel upload tasks

Hi @Chris1806 ,

 

Sorry for the answer is no.

The functions that you mentioned is not supported in Microsoft flow currently.

 

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Chris1806
Level: Power Up

Re: SAP to Excel upload tasks

This is not solved, I need SAP to Excel "Flow".

Chris1806
Level: Power Up

Re: SAP to Excel upload tasks

SOLUTION:   SAP TO EXCEL OR EXCEL TO SAP IS NOT SUPPORTED IN MS-FLOW.

abhicn
Level: Powered On

Re: SAP to Excel upload tasks

Hi,

This can be achieved using UI flow. Please find the screenshot of the flow I currently use.

 

image2.pngEXCEL list to SAP

View solution in original post

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

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 Solution Authors
Top Kudoed Authors
Users online (6,115)