Powerapps Canvas - IsMatch directly to Sharepoint List

Like (0) Share

Report

Posted on 28 Mar 2022 07:41:55 by RickyT

Hello,

I have a question regarding an app that I am experimenting with.

I have a list of names in my sharepoint list that I connected to my app.

I am trying to make it so that if the name in the text input does not match any name in my sharepoint list, the submission will fail.

Is it possible for me to use the "IsMatch" function and have it directly reference a Sharepoint list?

Looking forward to your help.

Categories:

Using Apps Using Formulas

General Questions

All responses (3)

Answers (1)

RickyT 62 on 28 Mar 2022 at 08:54:59

Like (1)

Report

Re: Powerapps Canvas - IsMatch directly to Sharepoint List

@Anonymous
Thank you for the help, your solution was able to do what I needed.

@Mira_Ghaly
Thanks for the suggestion too. I hope to use your method once I start learning more about flows and automation.
Verified answer

Community Power Pla... on 28 Mar 2022 at 08:05:38

Like (2)

Report

Re: Powerapps Canvas - IsMatch directly to Sharepoint List

@RickyT,
On submit button, instead of using IsMatch better way to use IsEmpty or IsBlank function like "If(!IsEmpty(Filter(SharePointList,ColumnName = TextInput.Text)),submitForm(),Notify("Invalied name",NotificationType.Error))"
Or if the column is multichoice filed then use "TextInput.Text in CoulmnName" instead of "ColumnName = TextInput.Text".

If this post helps you with your problem, please mark yours as an Accepted solution. If you like my response, please give it a Thumbs Up.
Mira Ghaly 11,409 Super User 2025 Season 1 on 28 Mar 2022 at 07:59:46

Like (0)

Report

Re: Powerapps Canvas - IsMatch directly to Sharepoint List

@RickyT

I would suggest to do a flow that checks if the name exists in the sharepoint list , so your flow simply takes the name as an Input, use GetItems with OData Filter to check if the name exists in the Sharepoint list , then your flow returns true or false to your powerapps based on whether the item exists or not and only perform the submit action if the return is true.

ISMatch function can't be used for your purpose , it is used to validate against regular expression or text

"The IsMatch function tests whether a text string matches a pattern that can comprise ordinary characters, predefined patterns, or a regular expression. The Match and MatchAll functions return what was matched, including sub-matches"

Hope this gives you an Idea!