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.

View solution in original post

Worked fine, thanks Warren, appreciate the help.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,537)