You’re offline. This is a read only version of the page.
Hello All and thank you to anyone that can help.
What I am trying to accomplish is to add a filter to a row of data for a daily spreadsheet(excel file) that is added to Sharepoint folder each day.
I was thinking I could use :"When a file is created in a folder" but can't seem to altar that file that is added.
Here's flow
File added
Row 17 of spreadsheet - Data - Filter
Save
Thats it. Just apply the filter to that row so users can click the drop down arrow to get to their data.
Ideas?
Hi @Anonymous,
It's unfortunate that if the Excel file is a new file, there is no way could do it.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank You for the help, I understand that however the file is a new file and new file name EACH DAY - same location. I want to somehow automatically apply the filter to each new file...
Hi @Anonymous,
I am not quite sure about your requirements. If you want to add a filter query to find the row in Excel table, you could refer to the following screenshot:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous did you try this?
#1
WarrenBelz
146,658
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (