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)

v-bofeng-msft on at

Like (0)

Report
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 (0)

Report

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

Was this reply helpful? Yes No
apham 19 on at

Like (0)

Report

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 on at

Like (0)

Report
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