cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Create a form that select all of item in Sharepoint List

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..

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

1 REPLY 1

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,899)