Notifications
Announcements
Hello,
Can Power automate flow trigger on data import from excel?
if I have more 1000 records in excel file , on import will power automate trigger?
Thanks,
Hi @Shafdev ,
If you use the 'When a row is added, modified or deleted' trigger, it will capture each row added to Dataverse when you import from Excel. Have in mind that you will have one flow run per each imported record.
This works, although I would advice that you go to the settings for the trigger and enable concurrency control. Depending on the flow complexity the number of flow runs and actions could be creater than limits set for the environment and you could risk that the flow will stall and fail.
You can read more about power automate cloud flow limitations here:Limits and configuration - Power Automate | Microsoft Learn
Hi, I have the same question. Would it be possible to trigger power automate based on the "imports" jobs table? where row is modified & the statuscode is "Completed". Although I can locate the table in power automate, the flow doesn't seem to trigger. When I use list row to retrieve the table content, it does seem to include all the import jobs in the table.
@r-glas
Does your trigger look something like this?
Yes, it does, exactly what I tried using! I have also tried using Data Import, Import data and Imports table as trigger points, but nothing triggers after I uploaded a csv into the model driven app.
Does it trigger if you do not add anything to the Select Columns and Filter Rows parameters?
No it doesn't either, I have tried using change type as "Added" but no luck there.
I can't think of anything else ☹ (apart from the possibility that it is a unique table which does not trigger the callbackregistration)
Please consider raising a ticket with Microsoft Support to see if they can answer.
The power automate is located inside my solution, do you know whether this has an impact? Would you also know how I can find the table within the environment? As it is not a table I can find inside the solution.
Update. Somehow the trigger now works. I suspect not all changes was published. @LinnZawWin Thank you for the help!
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 757 Most Valuable Professional
Michael E. Gernaey 322 Super User 2025 Season 2
MS.Ragavendar 209 Super User 2025 Season 2
