Using Power Automate with Excel to update SAP data

Показать описание

Without writing one single line of code you can use Microsoft Excel, Power Automate and the Customer Connector to update data in your SAP system using OData.
In this video we outline the steps to connect your Excel to your SAP system and use Power Automate to trigger updates to your SAP system.

0:28 Microsoft Power Platform
0:48 Overview of other scenarios
2:14 Scenario Overview
2:43 Starting with SAP Fiori
3:38 Creating Flow in Power Automate
5:28 Overview of Power Automate Flow
6:18 Demo - Update from Excel
8:26 Looking at the run history
9:48 Setting up this demo

* Integrating SAP data into Excel using OData – Code Free
* Update data from SAP via Excel using
* Custom development with Visual Studio / Visual Studio Code
* In-place using Script Lab
* Create Power Apps to visualize SAP Excel data
* Update SAP data via Power Apps and OData using Custom Connector and * Power Automate

SAP on Azure

Рекомендации по теме

Комментарии

Very nice concept :) Cheers
I have few queries, any inputs will be highly appreciated!
1) (Using SAP BAPI(API)/RFC ) Can we integrate Excel Data Directly with Power Automate and upload data. (Above example shows with ODATA)
2) Without using any VB scripting
3) Can we achieve to upload Excel data into SAP without any code in VB scripting .
4) Do we have the above option in Power Automate ?

Any information on above queries will be greatly appreciated ... Thank you and have a good day :)

chaitanyank

may i ask how you where able to create your Get Product and Update Product Connectors?
I am currently trying to replicate something very similar but unable to find the connectors.

lewiswilliams

Thanks for the video, but it is not clear how to prepare the automation process of getting reports using scripting and power automate to work and store them to a directory to prepare data analysis.

planetme

Thank you Sir!! I am in need of same process, however need to update excel data to SAP in app version. In this video I saw SAP is in web version. Any help please?

JAYDESH

Since we are new to this can you be able to explain from scratch..

sriranga

Using Power Automate with Excel to update SAP data

Microsoft Power Automate | Add data to Excel, get data from Excel, Conditions and Send Email | Guide

How to use Office Scripts and Power Automate to do Boring Excel Tasks for You

Excel in Microsoft Power Automate - Beginners Tutorial

Streamline Excel: Power Automate Tricks You Need to Know!

👩‍💻 How to use Office Scripts in Excel & Power Automate

Microsoft Power Automate | How to create a flow and update an Excel Table | Tutorial

Create a new Excel File in Power Automate and dynamically populate with a Table and Rows #Excel

Power Automate Tutorial for Beginners

Unlock Advanced Excel Automation with Power Automate | Transform Your Data Workflow!

Learn to Use Power Automate with Examples | Create Bulk PDF Files | Planner to Outlook

Use Power Automate to Send Excel Data to Outlook | Practical Use Case

Send Emails from Excel with Power Automate

How to Trigger a POWER AUTOMATE flow from EXCEL | For a selected row

Move data between workbooks automatically with Office Scripts & Power Automate | Excel Off The G...

How to Use Power Automate to Send Emails from Excel with PERSONAL Attachments

How to easily automate boring Excel tasks with Power Query!

How to automate invoice data copy to Excel in 1 minute

Automate Emailing Excel Task Reminders with ZERO Coding!

Excel in Power Automate for Desktop (Full Tutorial)

How to Sync Microsoft Excel with Microsoft Forms Responses Using Power Automate

Power Automate Export to Excel | Dynamically create Table, Columns & Add Rows to Excel | Send Em...

Add & Update Excel Data to SharePoint List using Power Automate | Excel Import using flow

Email Excel Reports with Power Automate & Office Scrips - One Click Automation 🤖

How to use Excel in Microsoft Power Automate Desktop