web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Flow Power automate Error
Customer experience | Sales, Customer Insights,...
Answered

Flow Power automate Error

(0) ShareShare
ReportReport
Posted on by Sebastien_borloju 15

Hi everyone,

I have created a Power automate Flow to insert and update opportunity data in Dynamics 365 Sales from an Excel File. 

When I add the action List rows from table in Excel online, I can insert only 256 rows in Dynamics. 

I have also an issue, Many lines which not contain data will be added in my database opportunity. 

I created a bulk deletion job to delete all opportunities when the topixmc and customer does not contain data. But I'm sure that's not the best solution. 

 Any suggestions please ? 

I have the same question (0)
  • Verified answer
    Mohamed GRAIB Profile Picture
    Mohamed GRAIB 2,504 Moderator on at

    Hi Sebastien, 

    You can get 100.000 rows with the action Excel Online (Lidt rows present in a table). You should just configure this action. 

    To configure the action. Just click in the action (...) then parameter and select pagination. Then select 100.000 in the field under the pagination. 

    Hope that's helpful for you. 

    Please mark the answer as verified if that's resolve your problem. 

  • Sebastien_borloju Profile Picture
    Sebastien_borloju 15 on at

    Thank you Graib,

    Have you a suggestion for my second issue please ?

  • Verified answer
    Mohamed GRAIB Profile Picture
    Mohamed GRAIB 2,504 Moderator on at

    Click on show advanced options in your action

    Then in the Filter rows field add this query :

    ne ''

    Try this and tell us if it's ok for you.

    Please mark the answer as verified if that's reslove your problem.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 81 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

#3
#ManoVerse Profile Picture

#ManoVerse 40

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans