cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnSchi17
Level: Powered On

Create or Update CDS Records from Excel

Hello

 

I have an Excel table with 10 rows - columns:
   part number
    Parts text 1
    Parts text 2

and a CDS entity with several 1000 rows - same columns as in Excel.

 

I would like to check for all Excel records wether a CDS record exists

If yes - update part text1
if no - create a new record in CDS

 

I'm just too stupid to create this flow.
Can you please help me and give me a complete solution.

 

Many thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
AnSchi17
Level: Powered On

Re: Create or Update CDS Records from Excel

Many hours have passed. But now I have the solution. Actually quite simple if you know the right tricks.

Her is my solution:

2017-10-01 23_55_12-Eigenen Flow bearbeiten _ Microsoft Flow.png2017-10-01 23_56_41-Eigenen Flow bearbeiten _ Microsoft Flow.png---

good night

 

 

 

 

 

 

 

View solution in original post

1 REPLY 1
AnSchi17
Level: Powered On

Re: Create or Update CDS Records from Excel

Many hours have passed. But now I have the solution. Actually quite simple if you know the right tricks.

Her is my solution:

2017-10-01 23_55_12-Eigenen Flow bearbeiten _ Microsoft Flow.png2017-10-01 23_56_41-Eigenen Flow bearbeiten _ Microsoft Flow.png---

good night

 

 

 

 

 

 

 

View solution in original post

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

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