cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

 

GauravG_0-1600023787104.png

@abm@CFernandes - can you please help!

Thanks, Gaurav

1 ACCEPTED SOLUTION

Accepted Solutions

I  am trying to accomplish something similar here.

So pasting the link- https://powerusers.microsoft.com/t5/Building-Flows/Delete-rows-from-excel-file-which-would-be-create...

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

View solution in original post

5 REPLIES 5
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

 

canada.PNG



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 www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Super User III
Super User III

@GauravG 

 

Hi Mate,

 

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

 

CFernandes_1-1600066787788.png

 

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

Thanks

I  am trying to accomplish something similar here.

So pasting the link- https://powerusers.microsoft.com/t5/Building-Flows/Delete-rows-from-excel-file-which-would-be-create...

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

View solution in original post

Helpful resources

Announcements
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.

secondImage

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)