Answered

Launching a OneDrive URL with a Search/Filter applied using text from a Gallery item?

(0) Share

Report

Posted on by AdamGill1965

311

I have a Text value in a Form that I want to use as a Search / Filter for Files which exist in my OneDrive. I have other processes which take "JobID" (a text Field) and prefixes files save on my OneDrive, such as:

FSL-0318_Order_Form.txt

FSL-0318_Returns_Form.txt

...etc...

What I need to do is provide a simple button which will include a "search" or "filter" criteria within the URL for the Launch code, so that a browser window opens to the OneDrive/SharePoint Folder - but which only displays the files which contain the JobID text, as a prefix. I have researched and found something like the following - and I am sure this is wrong because it opens the correct OneDrive / SharePoint folder - but it does not filter the contents for the specified JobID:

Launch("https://mycompany-my.sharepoint.com/pathtoonedrivefolder&view=7&q="& DataCardValue13.Text)

I feel sure that there are other parameters I can pass in the URL to Filter or apply a Search but I haven't found the correct syntax yet. Any pointers would be greatly appreciated - thanks!

Adam

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

AdamGill1965 311 on at

Like (0)

Report
Copy link

Link copied!

Sorry - resolving my own issue here but, for anyone who needs it the solution is:

Use the search facility on your OneDrive or SharePoint Folder (search for XXXXX) and copy out the result URL.
Next, insert your DataCardValue.Text in the same position as your search term in the URL, which is situated between q= and &view=

Something like this:

Launch("https:/mycompany.sharepoint.com/...etc.../onedrive.aspx?q=" & DataCardValue13.Text & "&view=7&id=....etc...")

Was this reply helpful? Yes No
alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @AdamGill1965

If you open your one drive from the web and do a search if you check the url that is generated and compare it with the one your are opening from power apps I think you will find out what are the missing parameters.

Was this reply helpful? Yes No
AdamGill1965 311 on at

Like (0)

Report
Copy link

Link copied!

Alaa,
This is exactly what I did and posted as a solution. I have marked up my response as the Solution I Accepted.
Adam

Was this reply helpful? Yes No