web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Trimming a URL and sea...

Power Apps

Answered

Trimming a URL and searching on value

(0) Share

Report

Report

Posted on by Vstar19

381

Hello,

I have a sharepoint table presented on a Power APP as a data table.

One of the columns on my data table is ID which lists all the ID.

I would like a user to come into the form, and search for the ID - However, instead of getting users to extract an ID from a URL, i would like them to insert the full URL into the search box, and i would like PowerApps to trim the URL to find the ID.

Every ID is in the same place inside of a URL, e.g. after the word ID, there is a / followed by the ID

https://mywebsite/ID/ekdh5e14-37954-41tk-bh07-6949487a3f97/Data/7365bb90-a412-4042-a9c4-02e12bde8ebf/Section

If a user was to come into a search box, insert the above URL, can PowerApps extract the ID and then search on it? (in the this case, the ID is ekdh5e14-37954-41tk-bh07-6949487a3f97), so the data table will only show that ID?

If so, could someone show me how?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Vstar19,

To extract the ID you could use a couple of split functions:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-split#substring-extraction

Below is an example of that approach with an input and label:

First(Split(Last(Split(UserInput.Text,"ID/")).Result,"/Data")).Result

Join the conversation