Power automate flow trigger on data import

[Shafdev]

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,

[rzaneti]

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.

[wwweber]

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

[r-glas]

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.

 

[LinnZawWin]

@r-glas 

Does your trigger look something like this?

[r-glas]

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.

 

[LinnZawWin]

@r-glas 

Does it trigger if you do not add anything to the Select Columns and Filter Rows parameters?

[r-glas]

No it doesn't either, I have tried using change type as "Added" but no luck there.

[LinnZawWin]

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.

[r-glas]

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.