You’re offline. This is a read only version of the page.
Announcements
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
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?
Hi @Vstar19,
To extract the ID you could use a couple of split functions:
Below is an example of that approach with an input and label:
Share
Report
All responses (
Answers (
First(Split(Last(Split(UserInput.Text,"ID/")).Result,"/Data")).Result
