I am trying to set up an email blacklist in powerapps. I have a list of emails in SharePoint that I do not want submitting a form through my powerapp so when they enter their email in the email submission box I have set up and it matches an email on the SharePoint list, I want to send an error message to the screen. How can I put this check into the powerapp? Is there a way to check a text input in a powerapp against a SharePoint list?
Thanks in advance for the help!
Hi @jviernes ,
First of all, what is the column type of your email column in this list? I assume that it is a text column, then please set below formula in the OnSelect property of your submit button to achieve this:
If(IsBlank(Lookup(ListName,EmailColumnName=TextInput1.Text)),SubmitForm(Form1),Notify( "You cannot use this email address.", NotificationType.Error ))
My SharePoint list is named "Email Blacklist" and the column is just a single text column in the list called "Blacklist". The text input is named "ParentEmailAddress".
It is not recognizing the column name "Blacklist" and is throwing an error for that part.
Any suggestion on how to appropriately name the column name in the formula?
I set up the formula as:
If(IsBlank(Lookup('Email Blacklist',Blacklist=ParentEmailAddress.Text)),SubmitForm(DataPage),Notify( "You cannot use this email address.", NotificationType.Error ))
Hi @jviernes ,
This formula should work as expected. What issue did you run into?
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand