How to filter drop down list box based upon another Field ? - InfoPath Dev Sign in | Join | Help in General InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » General » How to filter drop down list box based upon another Field ? Use our Google Custom Search for best site search results. How to filter drop down list box based upon another Field ? Last post 12-01-2016 10:39 PM by Imran786. 2 replies. Page 1 of 1 (3 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 11-25-2016 06:39 AM Imran786 Joined on 10-06-2016 Posts 19 How to filter drop down list box based upon another Field ? Reply Contact In my form i add drop down list box i bind the list to this drop down list in this list contains large no of data so i want to filter the drop down. So i add one text box before the drop down. I want to filter the drop down value based on text box enter text it work but issue is that If i enter Xyz then drop filter show only Xyz filter result but not showing the xyz. I means case sensitive issue. I filter the drop using the contains filter to check is textbox value is in drop down. Filed under: info Path form, #infopath2013, Info path form controls 11-28-2016 04:55 PM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,290 Re: How to filter drop down list box based upon another Field ? Mark as Not AnswerMark as Answer... Reply Contact Unfortunately, the only way around case sensitivity is to use the translate function in your filter - so you'd compare translate(field1, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz') to the other field - and translate that as well. Hilary Stoupa 12-01-2016 10:39 PM In reply to Imran786 Joined on 10-06-2016 Posts 19 Re: How to filter drop down list box based upon another Field ? Mark as Not AnswerMark as Answer... Reply Contact Thanks Hilary it work. Page 1 of 1 (3 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
Use our Google Custom Search for best site search results.
Unfortunately, the only way around case sensitivity is to use the translate function in your filter - so you'd compare translate(field1, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz') to the other field - and translate that as well.