Answered

Check if URL exists from sharepoint column

(0) Share

Report

Posted on by Devinm501

Hi,

I am creating a PowerApp to automate the creation of SharePoint sites. Currently i have a list that is populated by the PowerApp to contain all the relevant information on the new site. I have a column in this list called "SiteURL", then in the powerapp i have a text input called "URL". My data source is called "Requests", basically i want a way to check the "URL" input against the "SiteURL" column to see if it has already been entered and then display an error message to the user prompting them to enter a different URL.

If(IsBlank(LookUp('Workspace Requests Dev', SiteUrl = URL.Text)),"Invalid" )

Here is the direction i was going in but unsure if this is even remotely correct. Any help on this issue would be brilliant thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If(CountRows(Filter('Workspace Requests Dev', SiteUrl = URL.Text))>0,"Valid","Invalid")

Was this reply helpful? Yes No
Devinm501 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the response, so what i have now is the following:

If(CountRows(Filter('Workspace Requests Dev', SiteUrl = URL.Text))>0,"Valid","Invalid") ||

Navigate(SummaryPage,ScreenTransition.Fade)

I have entered a URL that is already present in the list however no message is displayed and it continues onto the next screen? am i missing something in between?

Thank you,
Devin

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If you want to navigate to the next screen when does not exist then:
If(CountRows(Filter('Workspace Requests Dev', SiteUrl = URL.Text))>0,Notify("Valid"),Navigate(SummaryPage,ScreenTransition.Fade)

Was this reply helpful? Yes No
Devinm501 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Works perfectly thank you!

Was this reply helpful? Yes No