web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Import Excel Data into...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested Answer

Import Excel Data into Dynamics Sales

(0) Share

Report

Report

Posted on by LA-03111723-0

11

I created a Power Automate flow to extract data from an Excel spreadsheet stored in SharePoint and send the data to specific fields in Dynamics.

I built the entire structure of the flow, but the last step — updating rows — is not working. It seems that when selecting the table ID, it automatically creates an “Apply to each” loop and does not proceed with the update as expected.

Has anyone experienced this before?

Below are the screenshots/evidence:

Categories:

Dynamics 365 general

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

André Arnaud de Cal... 303,354 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you please translate your question in English? This is an English lingual forum. In case your question is about Power Automate Flow, you can probably better ask your question on the Power Platform Community forum: Microsoft Power Platform Community Forum Thread

Was this reply helpful? Yes No
Suggested answer

PerezAguiar Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey!

This is going to perform a get rows (despite you're only getting one) on Sharepoint/excel. Now, on the execution, the step with the 27seconds, as you indicate is a "for each" so it means that for each row (despite there's only 1) it will perform the update. If the content inside the loop is not working, then you should verify the Condition that is evaluating. Seems you're checking if Area = "Dentística"

Also, on the trigger, you can check the JSON that is being triggered here and validate if the Area is correct

2 people found this reply helpful.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

Pallavi Phade 102 Super User 2026 Season 1

#2

Abhilash Warrier 55 Super User 2026 Season 1

#3

ManoVerse 53 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans