News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Open URL stored on the...

Power Apps - Building Power Apps

Answered

Open URL stored on the second column sharepoint list.

(0) Share

Report

Report

Posted on by Sormick

361

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:

General Questions

All responses Img

All responses (7)

Answers Img

Answers (1)

DBO_DV 4,239 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?
Sormick 361 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.
Verified answer

DBO_DV 4,239 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.
Sormick 361 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.
DBO_DV 4,239 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.
Sormick 361 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.
DBO_DV 4,239 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)))

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Give Back to the Community this Month

Quick Links

Leaderboard

#1

WarrenBelz 143,591

#2

RandyHayes 76,308

#3

Pstork1 64,090

Leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value

How to patch multiple records at once

Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans