Microsoft Dynamics 365 | Integration, Dataverse...

Import Excel Data into Dynamics Sales

(0) Share

Report

Posted on by LA-03111723-0

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 (2)

Answers (0)

André Arnaud de Cal... 300,961 Super User 2025 Season 2 on at

Like (0)

Report

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

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

1 people found this reply helpful.

Was this reply helpful? Yes No