Problem with Two dropdowns to filter gallery

[nchandran]

I would like to have two dropdown list to filter the gallery based on Order No and PartNo but im getting syntax errors. Tried two different syntax in Distinct(Filter(ConsumableWithdraw, MasterID=GalleryCRWelderInfo.Selected.ID),Order=DropdownOrdNo.Selected,PartNo=DropdownPartNo.Selected) or tried Distinct(Filter(ConsumableWithdraw, OrderNo=DropdownOrdNo.Selected, PartNo=DropdownPartNo.Selected), MasterID=GalleryCRWelderInfo.Selected.ID) OrderNo and PartNo are columns from the sharepoint list called ConsumableWithdraw. Dropdown to search Order No is DropdownOrdNo & Dropdown to search Part No is DropdownPartNo.

MasterID gets the information from the ID in the primary Gallery GalleryCRWelderInfo. Screenshot below.

[v-bofeng-msft]

Hi @nchandran :

Plese try this fromula:

Distinct(
   Filter(
      ConsumableWithdraw, 
      MasterID=GalleryCRWelderInfo.Selected.ID,
      Order=DropdownOrdNo.Selected,
      PartNo=DropdownPartNo.Selected
      )
)

Best Regards,

Bof

[nchandran]

Hi it doesn't work, still getting the red swiggilies.

[v-bofeng-msft]

Hi @nchandran :

Could you tell me:

What is Order and PartNo's data type?

What is DropdownOrdNo and DropdownPartNo?What are they items property?

Please try:

Distinct(
   Filter(
      ConsumableWithdraw,
      MasterID=GalleryCRWelderInfo.Selected.ID,
      Order=DropdownOrdNo.Selected.ColumnName,
      PartNo=DropdownPartNo.Selected.ColumnName
      )
)

Because of the lack of information, I cannot be sure that my answer is 100% correct.If there is still an error, could you consider providing more details?

Best Regards,

Bof

[nchandran]

For  both Dropdown , items is ConsumableWithdraw.

[v-bofeng-msft]

Hi @nchandran :

Please try this formula:

Distinct(
   Filter(
      ConsumableWithdraw, 
      MasterID=GalleryCRWelderInfo.Selected.ID,
      Order=DropdownOrdNo.Selected.Order,
      PartNo=DropdownPartNo.Selected.PartNo
      )
)

Best Regards,

Bof

[nchandran]

I got this screenshot. Error is still there. Master ID is a lookup column (belongs to secondary sharepoint list) which points taps on ID column belonging to primary sharepoint list.

[v-bofeng-msft]

Hi @nchandran :

I’m not sure what your reason for using Distinct is, I assume you want to de-duplicate according to Title column.

Please try this formula:

ForALL(
  RenameColumns(Distinct(
     Filter(
        ConsumableWithdraw, 
        MasterID.value=GalleryCRWelderInfo.Selected.ID,
        Order=DropdownOrdNo.Selected.Order,
        PartNo=DropdownPartNo.Selected.PartNo
        ),
      Title
  ),"ID","IDD")
  LookUp(ConsumableWithdraw, ID=IDD)
)

 Best Regards,

Bof

[nchandran]

Getting this error.

[v-bofeng-msft]

Hi @nchandran :

You don't seem to use the formula I provided.

ForALL(
  RenameColumns(Distinct(
     Filter(
        ConsumableWithdraw, 
        MasterID.value=GalleryCRWelderInfo.Selected.ID,
        Order=DropdownOrdNo.Selected.Order,
        PartNo=DropdownPartNo.Selected.PartNo
        ),
      Title
  ),"ID","IDD")
  LookUp(ConsumableWithdraw, ID=IDD)
)

From the screenshot, the reason for the error is that Distinct uses the wrong syntax.

Distinct( Table, Formula )

I think this link will help you a lot:

Distinct function in Power Apps 

Best Regards,

Bof