cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SandraSoniec
Helper II
Helper II

How to connect to Excel table loaded with Power Query?

Hi,

I would like to update CDS records using power automate using data from Excel.

My data source is an Excel workbook stored on OneDrive. Excel connects to a data from the web and I am using Power Query to transform the data as needed. When I try to connect the workbook in  power automate with action "List rows present in a table", I cannot select any table "NO DYNAMIC CONTENT AVAILABLE". The workbook has two tables that are properly formatted as tables. 

 

I have used the same workbook already as source with dataflow. The only problem is that my primary field may change values. That's why I am looking for alternative with power automate for being able to update primary field values. Otherwise new records would be created instead of updates.

 

It would work if I copy and paste the table values in a new workbook and format them as table but then I would lose the refresh capability. Any suggestions? 

1 REPLY 1
SandraSoniec
Helper II
Helper II

The issue appears to be a XML-Map that I used in my workbook. This feature is not supported in Excel for web. Tried another workbook with a power query and web resource, which works fine. Any alternative approaches how I could use the XML data source with power automate?

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,501)