Answered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @Anonymous 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

Was this reply helpful? Yes No
CFernandes 8,504 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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-created-in-the-flow/m-p/691542#M93465
I will mark this as solution to point to the right thread

Was this reply helpful? Yes No