cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mike2020
Regular Visitor

Filter Table with Datacard Values

Hello All,

Having some issues I'm hoping you can help with.

I have a form which a person will input details.

The form has a mix of drop downs and free numerical entry.

gvalue, pvalue, CCDim & pbvalue datacards.

 

the code below is from the items selection property on my table to view the results of the selections referring bacl to lldb SharePoint list.

This works mostly.

I want to be able to filter the table using the numerical value in CCDim but it needs to be not an exact = which i have working but equal to or within 20mm either side of the value inputted at CCDim datacard in the form.

 

Does this make sense? Looking forward to your replies. Thank you.

 

 

If((!IsBlank(gvalue.Selected.Value) || !IsEmpty(gvalue.Selected.Value))
&&(!IsBlank(pvalue.Selected.Value) || !IsEmpty(pvalue.Selected.Value))
&&(!IsBlank(CCDim.Text) || !IsEmpty(CCDim.Text))
&&(!IsBlank(pbvalue.Selected.Value) || !IsEmpty(pbvalue.Selected.Value)),
Filter(
lldb,
Title = gvalue.Selected.Value &&
LSpade = pvalue.Selected.Value &&
'C Center (mm)' = CCDim.Text &&
'P Bar' = pbvalue.Selected.Value))

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Mike2020 ,

It worked in as far as that what my code was meant to do - try this instead if you want all values completed.

Filter(
   lldb,
   Title = gvalue.Selected.Value &&
   Spade = pvalue.Selected.Value &&
   Abs('C Center (mm)' - Value(CCDim.Text)) <=20 &&
   'P Bar' = pbvalue.Selected.Value
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

4 REPLIES 4
WarrenBelz
Super User
Super User

Hi @Mike2020 ,

Try this structure - note the Len() syntax I find better for reliably detecting blank values

Filter(
   lldb,
   (Len(gvalue.Selected.Value) = 0 || Title = gvalue.Selected.Value) &&
   (Len(pvalue.Selected.Value) = 0 || Spade = pvalue.Selected.Value) &&
   (Len(CCDim.Text)= 0 || Abs('C Center (mm)' - Value(CCDim.Text)) <=20) &&
   (Len(pbvalue.Selected.Value) = 0 || 'P Bar' = pbvalue.Selected.Value)
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Hi Warren,

This did not work unfortunately.

When all the drop downs are blank the whole list is showing. there should be nothing showing unless all the conditions are met.

 

 

Thanks for your help so far, it's nearly there.

Hi @Mike2020 ,

It worked in as far as that what my code was meant to do - try this instead if you want all values completed.

Filter(
   lldb,
   Title = gvalue.Selected.Value &&
   Spade = pvalue.Selected.Value &&
   Abs('C Center (mm)' - Value(CCDim.Text)) <=20 &&
   'P Bar' = pbvalue.Selected.Value
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Worked fine, thanks Warren, appreciate the help.

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.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,707)