Create a form that select all of item in Sharepoint List

[Anonymous]

Hi All,

May i know how to do a form that whenever user click on that choice, it will automatically refill all the information in the sharepoint list.

for example i have an item of hardware type(Text), serial number(number), analyst name(person/group) and approval(choice)

whenever i click a dropdown of hardware type and choose any data from it for example mouse, it will show all of the list of that item as above automatically.

if i choose other hardware types, it will also change the data in that.

thank youuu..

[jlindstrom · Accepted solution]

Hi @Anonymous 

You don't want a form, you want a gallery or a data table. Connect it to your Sharepoint list. This will display all items in the list.

Now you want to filter it 

Add your drop-downs to the top of the gallery. Set the items of the gallery using a collection. In the collection add an item called "All."

Then filter the gallery or data table  using an expression like this

What if you want to have multiple dropdowns and the ability to filter by only the ones where you select a value? This can be achieved by populating your drop-downs from a collection and including an all value in the collection as the first option.

Then when you build your filter it can be something like this:

 

Filter(

company_List,

Dropdown1.Selected.Value = "All" || Industry = Dropdowndown1.Selected.Value

Dropdown2.Selected.Value = "All" || City = Dropdown2.Selected.Value,

Dropdown3.Selected.Value="All" || Office =Dropdown3.Selected.Value  Office

)
 

Of course replace the list  name and the names of the dropdowns and the field references.

the magic here is in the "All." It allows you to only select a value in one or two of the dropdowns and return the desired data.

@Anonymous if this answers your question, please mark it as a solution.