Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Filter an excel file in SharePoint and download the filtered version of excel on OneDrive

Hi folks,


With the flow below, i am trying to enter the value of a Country- example Canada.

Then, go to an excel hosted in SharePoint having a column Country. I want to filter this column based on the country i entered- i'll get that from dynamic content as shown below.

Now, the issue is what should be the next step- how do i get the results in an excel.

I want the filtered version of this excel on OneDrive. Please suggest



@abm@CFernandes - can you please help!

Thanks, Gaurav


Accepted Solutions

I  am trying to accomplish something similar here.

So pasting the link-

I will mark this as solution to point to the right thread

View solution in original post

Super User II
Super User II

hi @GauravG  you are doing well work in your flow, just please try cliking Test and then I'll perform the trigger action.

You are going to see a form to enter the data you want to filer, that could be your Country Canada see



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!

If you want you can follow me at Quieres contenido en español? Síguenos en Power Automate LA
Super User III
Super User III



Hi Mate,


My way of filtering the Excel is a bit different as this works for me.




Filter array

From - value

Condition - Country is equal to Canada


Apply to Each -

Body - Output of the 'Filter' action.


Create items-

ID - items('Apply_to_each')['ID']

Review - items('Apply_to_each')['Country']


If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!


@CFernandes Appreciate your response.

I am looking to move data from a excel in SharePoint to an excel in OneDrive. The excel in OneDrive doesn't exist- so may have to copy the file from SP and then delete rows in OneDrive as i don't want to affect the original file in SP.

The method above seems good and i will try it- but still unaware as to how a workbook/ table would be created from scratch in OneDrive? Kindly suggest!

Helper V
Helper V

@abm Thanks for connecting- was able to create file using get content using path in OneDrive

Will try the other remaining steps and update on progress here


I  am trying to accomplish something similar here.

So pasting the link-

I will mark this as solution to point to the right thread

View solution in original post

Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (5,372)