cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Lookup List + filter datas

Hello;

 

In my applicaion i have 2 sharepoint list : Piece and Produit.

In Produit , id_Piece is lookup on Piece => id_Piece.

 

1) In PowerApps : how is it possible to correctly display my lookup fields ?

2) How is possible to have my sharepoint column wiht my link PDF in my list of Piece ? 

3) How is it possible to manage a PDF in powerapps ?

 

After these technicals points , i would like know how is it possible to make a filtering system on the columns of my grids 

=> Exemple if my piece have a typical metadata (plastic, metal, ...) How is it possible to filter on plastic piece or metal piece ??

with this icon => Filter.PNG

Piece.PNGPiece_PowerApps.PNGProduit.PNGProduit_PowerApps.PNG

Thank you for your help 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Lookup List + filter datas

Hi @bansay ,

1)Do you want to filter id_Piece based on the selection of Produit list?

I've made a similar test for your reference:

Create two data tables.

Set the first data table's data source: Piece

Set the second data table's data source: Produit list

Set the second data table's Items:

 

Filter(Produit list,id_Piece in data table1.Selected.id_Piece.Value)

 

Please note that  "data table1.Selected.id_Piece" will return a table with two columns: Id and Value.

I notice that maybe in your location, you use ";" instead of ",".

So you could try:

 

Filter(Produit list;id_Piece in data table1.Selected.id_Piece.Value)

 

 

2)Could you describe more clearly about what you want? Do  you want to save PDF link in your sharepoint list?

If so , you insert a Hyperlink column in your list.

 

3)Could you describe more clearly about "manage" PDF?

Do you want to update the content of the PDF?

I'm afraid it's not supported to make this in PowerApps currently.

For now, you could only display PDF in PDF viewer , launch the  website of the PDF, download the PDF file and generate a PDF in PowerApps.

Other functons about PDF have not been supported.

 

4)In your sharepoint list, you can not filter items.

You could create an app connected with sharepoint list.

Insert several buttons like the image you mentioned.

Set the first button's OnSelect: 

Set(var1,"plastic")

Set the second button's OnSelect: 

Set(var1,"metal")

Set the gallery's Items :

If(IsBlank(var1),piece,
   var1="plastic",Filter(piece,metadata="plastic"),
   var1="metal",Filter(piece,metadata="metal")
   )
 
 

115.PNG

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Lookup List + filter datas

Hi @bansay ,

1)Do you want to filter id_Piece based on the selection of Produit list?

I've made a similar test for your reference:

Create two data tables.

Set the first data table's data source: Piece

Set the second data table's data source: Produit list

Set the second data table's Items:

 

Filter(Produit list,id_Piece in data table1.Selected.id_Piece.Value)

 

Please note that  "data table1.Selected.id_Piece" will return a table with two columns: Id and Value.

I notice that maybe in your location, you use ";" instead of ",".

So you could try:

 

Filter(Produit list;id_Piece in data table1.Selected.id_Piece.Value)

 

 

2)Could you describe more clearly about what you want? Do  you want to save PDF link in your sharepoint list?

If so , you insert a Hyperlink column in your list.

 

3)Could you describe more clearly about "manage" PDF?

Do you want to update the content of the PDF?

I'm afraid it's not supported to make this in PowerApps currently.

For now, you could only display PDF in PDF viewer , launch the  website of the PDF, download the PDF file and generate a PDF in PowerApps.

Other functons about PDF have not been supported.

 

4)In your sharepoint list, you can not filter items.

You could create an app connected with sharepoint list.

Insert several buttons like the image you mentioned.

Set the first button's OnSelect: 

Set(var1,"plastic")

Set the second button's OnSelect: 

Set(var1,"metal")

Set the gallery's Items :

If(IsBlank(var1),piece,
   var1="plastic",Filter(piece,metadata="plastic"),
   var1="metal",Filter(piece,metadata="metal")
   )
 
 

115.PNG

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,398)