Export data with filtering

(0) Share

Report

Posted on by LuanDT

103

I'm using this syntax is

OnSelect:

Launch("https://*Your SharePoint Site adress*/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={*Enter List ID*}&View={*Enter View ID*}&CacheControl=1")

to export data from SharePoint List but it exports full data, so I want to filter when user clicks it exports user department's data.

This is list on SharePoint. Is there another function I can use?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

SpongYe 5,603 Super User 2025 Season 2 on at

Like (0)

Report

Hi @LuanDT

For string values, you can simply add this to the end of the list’s URL to filter it as specified using URL parameters.

For more information about the demo/guide see the link:
https://natechamberlain.com/2020/05/09/how-to-filter-a-sharepoint-list-or-library-using-url-parameters/

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
LuanDT 103 on at

Like (0)

Report

@SpongYeit's not a string value because people from different departments will see their own department's data

Was this reply helpful? Yes No