Search option in reduction form

(0) Share

Report

Posted on by BlueRSK

127

I have a Redaction form, with places for inputs.

Like these ones. Can i use search option in one of the input form? And how can i realize it? I want to input text in this form, and it extracts relevant information from Share Point list. Like my column in sharepoint is about birds. I start input text like "Bla" and under this form i want to see list with proposals that previously inputed "Black shama", "Black siskin".....

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Verified answer

madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi!

It sounds like perhaps you want to use a combobox control

First, set the datasource to be your SP List.

Then, you'll want to enable Searching, and then under fields, set the primary text to be the birds column, and the searchfield to be the birds column.

This will result in something which looks like this(I used test data):

Hope this helps!

Was this reply helpful? Yes No
BlueRSK 127 on at

Like
a
(0)

Report
Copy link

Link copied!

And if i found my bird, like woodpecker and chose it, will it save in my sharepoin list?

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Once you have a value selected you can use it however you like, using additional formulas.

For example, to save the value to a Sharepoint list when it's selected, you could use a Patch function in the control's OnChange property.

However, its worth noting that this combobox will only return values already in your sharepoint list - nothing else, without using a different data source for it.

Was this reply helpful? Yes No
BlueRSK 127 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you write to me an example of patch function using combo box? I have a bit another syntax.

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Sure! 🙂

This is very much just a template, but it follows the general pattern you need.

You'll have to add in your datasource name and columns name(s).

Patch(*YourDataSource*, Defaults(*YourDataSource*), {*BirdsColumn*: Self.Selected})

Was this reply helpful? Yes No
BlueRSK 127 on at

Like
a
(0)

Report
Copy link

Link copied!

Here is my formula. Just like at an example. But it is still wrong. i have no idea
Invalid name text not recognized, the patch function has several invalid values

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Comboboxes don't have a .text property - you'll need to use "Combobox2.Selected.FieldName" here. You'll have to replace fieldname(I believe) with the column name for the birds.

Was this reply helpful? Yes No
BlueRSK 127 on at

Like
a
(0)

Report
Copy link

Link copied!

For this moment i have no problems and errors but when i add " .Selected " , i get an error.
The type of this argument OData__x2116__x0432__x002f__x0447 does not match the expected type "Text".

Was this reply helpful? Yes No
BlueRSK 127 on at

Like
a
(0)

Report
Copy link

Link copied!

So, it thinks that ComboBox2 has "Text" type but why?

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I think you need to add a field name after "Combobox2.Selected"

perhaps something like "Combobox2.Selected.Value"

However, ".Value" might not be the appropriate field name; See if you can find the right field name for this.

We'll need the items property to find this correctly otherwise.

Was this reply helpful? Yes No