Open URL stored on the second column sharepoint list.

(0) Share

Report

Posted on by Sormick

566

I have a sharepoint list which have two columns:

Title
URL

I have this formula on a button

Launch(First(Filter(OPBLISTE; StartsWith(Titre; TextInput1.Text))).URL)

I need to launch the URL stored on the column 2 of my sharepoint list after entering the text value of column 1 on my textinput1.

The issue i have is that the URL opened is not the one corresponding to my entered text on textinput1

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (0)

Report
Re: Open URL stored on the second column sharepoint list.

Hey @Sormick ,

My advice would be to check what this part of your Filter returns.
First(Filter(OPBLISTE; StartsWith(Titre; TextInput1.Text)))

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report

Re: Open URL stored on the second column sharepoint list.

I can see that this filter returns another value which is stored on a different row that the one i need on the column 2 of my sharepoint list. Don't know why it is not returning the same row as my textinput value.

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (0)

Report

Re: Open URL stored on the second column sharepoint list.

Try to drop the First to see if maybe there are more values matching your filter.

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report

Re: Open URL stored on the second column sharepoint list.

Sorry but what would be the formula without "First " ?
Did not worked for me.

Was this reply helpful? Yes No
Verified answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (0)

Report
Re: Open URL stored on the second column sharepoint list.

Filter(OPBLISTE; StartsWith(Titre; TextInput1.Text))
You need to put into a gallery.

Was this reply helpful? Yes No
Sormick 566 on at

Like (1)

Report

Re: Open URL stored on the second column sharepoint list.

I finally found what is wrong. My formula refers to the wrong textinput. Sorry for the inconveniance. Thank you for your support.

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (0)

Report

Re: Open URL stored on the second column sharepoint list.

No Problem. Could you please mark an answer as Solution to close this topic?

Was this reply helpful? Yes No