Forum Discussion
Onelake trigger to Ingest CSV
As a solution I created data flow in Fabric to append data to a table in the Onelake and I trigger it via Power Automate "when a file is created" in a specific SharePoint folder.
Hi, thanks, I bumped into those triggers for blob storage events but was not sure if that could be used in the scenario in which we drop csv files on a specific location.
Should you then first drop the csv file in a blob container before such a trigger can be used?
thanks
- AndyDDC
Most Valuable Professional
Well the trigger will react to events in the storage account/onelake, so you can setup the trigger first then copy/move/create CVS files in the relevant location. The trigger should fire when the fire arrives.
----------------------------------------------------------
If my reply has been useful please consider providing
kudos and marking as the solution for others to find
----------------------------------------------------------
- NandanHegde
Super User
Hi AndyDDC
My understanding was this event trigger is only for Azure blob storages and not one lake.
Am I missing anything here? Has the support for event trigger via One Lake file section been enabled?- AndyDDC
Ah no...OneLake not activated yet, that's annoying. So only Azure Data Lake Gen2 accounts are supported.
