Only allow users enter text that exist in another data source?

(0) Share

Report

Posted on by apham

Hello,

I have two SharePoint lists, Account Request 1 and Account Request 2.

The Account Request 2 SharePoint list has a field named Companylookup that contains all the company names. (Apple, Google, Amazon, etc.... )

On the Account Request 1 SharePoint list I have a field named Company. I want users to type in the company name on this field that only exists on the Companylookup field from Account Request 2 or else throws an error message. Could you please show me how I can accomplish this using PowerApps form?

Thank you.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @apham :

Could you please tell me what Companylookup field is?Is it a text filed?

I assume Companylookup field is a Text filed.Please try:

Set the textinput control of "Company" field's OnChange property to:

If(IsBlank(Lookup('Account Request 2',Companylookup=Self.Text)),Notify("Error Message"))

Best Regards,

Bof

Was this reply helpful? Yes No
apham 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Bof, I'm sorry, the Companylookup field is number field.
Thanks.

Was this reply helpful? Yes No
apham 19 on at

Like
a
(0)

Report
Copy link

Link copied!

I took a different approach. I created a combobox in the Company Datacard

I set the Default property for Company text box
If(Form6.Mode = FormMode.View, Parent.Default, Concat(ComboBox7.SelectedItems,(CompanyLookup)))

I set the Items property for the ComboBox

Now, how do I prevent users from entering a value that does not exist from the dropdown list? I want to put a message like, "value must exist from the list below") Thank you.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @apham :

Please try----

Set the textinput control's OnChange property to:

If( IsBlank( Lookup( 'Account Request 2', Companylookup=Value(Self.Text) ) ), Reset(Self);Notify("value must exist from the list below") )

Best Regards,

Bof

Was this reply helpful? Yes No