Power Platform Community Forum Thread Details

Hi,

I am new to PowerApps and looking to build an application which has multiple validations.

One of the requiremnts is that on Button1 click, take value from TextBox1 and TextBox2, and then query a SharePoint List1.

If there is a list item in List1 which has entry for both TextBox1 and TextBox2 (and TextBox1 = TextBox2 ), then return True or else return False.

Now, on True submit the form and on Flase, show error message.

Will appreciate any help in this regard. Thanks in advance.

Categories:

Building Power Apps

Hi @ashish1183,

For TextBox1 and TextBox2, do you mean TextInput control?

Further, would you please explain a bit for "and TextBox1 = TextBox2 " here?

If here they indicate to TextInput control, then we could take a try with the formula below:

If(
 IsEmpty(
 Filter('Testing list',
 Title=TextInput1.Text,
 Title=TextInput2.Text)),
 "No record found",
 SubmitForm(EditForm1)
 )

IsEmpty function checks whether the Filter would return a blank table, and if it is true (which means the filter gives a blank result), the if function would give Text Message"No rcord found", if there is record found under the SharePoint list, it will then submit the Editform.

For TextInput1 an TextInput2, the text input would match the title column in the SharePoint testing list, and the multiple conditions in Filter function are in the And logic.

Adding the function reference:

Filter, Search, and LookUp functions in PowerApps

IsBlank and IsEmpty functions in PowerApps

If function in PowerApps

Please post back if you need any further assistance.

Regards