Trigger when file uploaded and using file in flow

(0) Share

Report

Posted on by moragb

Is it possible (and how on earth do you do it if it is) to kick a flow off when an excel document is uploaded to a folder in SharePoint?

I get an excel file uploaded to a folder monthly by another team - it's never the same filename, but always an excel doc.

Id like to have this upload as the trigger, then list rows in this file and filter by School=Eng AND Level=UG (filter array?) then save a csv file on this basis.

Is this possible?! I have it working on a manual trigger, with one filter using OData in List Rows, but cannot get it to work using a filter array, nor upload as trigger. Any suggestions GREATLY appreciated!

Categories:

Using flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

HenWang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @moragb ,

You can use below trigger to trigger flow:

As to the filter query, please make sure the "School" and "Level" are both exactly the column name in your table.

And you need to format the query in below schema:
School eq 'Eng' and Level eq 'UG'

Best Regards,
Hen Wang

Was this reply helpful? Yes No