Powerapps Canvas - IsMatch directly to Sharepoint List

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
RickyT 62 on at

Like (1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No