I have a power app form that is populated from a sharepoint list. On the form I have a combo box called cmb_InducteeType. I wish to hide/show certain form items dependent on whether that combo box contains the string "staff". The combo box options are "Staff", "Student", or "Visiting Staff". So if "Staff" or "Visiting Staff" is selected various form elements should be made visible. The thing that is driving me crazy is the the find function only seems to work if the text to be searched is an exact match to the ‘within text’.
so, if cmb_InducteeType.Selected.Value is "staff"
Find(Lower(cmb_InducteeType.Selected.Value), "staff") returns 1 – OK
if so, if cmb_InducteeType.Selected.Value is "visiting staff"
Find(Lower(cmb_InducteeType.Selected.Value), "staff") returns blank – Not OK, I think it should re turn 10
and if cmb_InducteeType.Selected.Value is "visiting staff" and I change the ‘within text’ to "visiting staff"
Find(Lower(cmb_InducteeType.Selected.Value), "visiting staff") returns 1 – which is OK also.
So basically, It only works with exact matches, which kind of defeats the purpose of the function.
Can somebody please tell me what I am doing wrong
You need to reverse the parameters in your formula :
Find( "staff"; Lower(cmb_InducteeType.Selected.Value))
Have a good day
Answered By – Nackoo
Answer Checked By – Robin (BugsFixing Admin)