Filtering Form component based on combo box

(0) Share

Report

Posted on by Mahesh005

Hi Team,

I have form where users need to add hours of the records which combo boxes are filtering.

i have 4 combo boxes where users need submit the form against the selected values in the form.

for e.g. i have employee name , project name , employee location, hours , 22/9/2023, 29/9/2023, 4/10/2023

i have a form with dates like 22/9/2023, 29/9/2023, 4/10/2023. where users will and fill against employee name selected in combo box and project name selected in project name combo box and employee location selected in project name.

i have tried writing the code in item property of the form like lookup(datasource, employeename = cmbemployeename.selected.value && projectname = cmbprojectname.selected.value && employee location = cmbemploc.selected.value) but it is not working.

Any help is Thankful.

Thanks & Regards,

Mahesh

All responses (2)

Answers (0)

ivan_apps 2,189 on at

Like (0)

Report

Re: Filtering Form component based on combo box

Verify the values of these items:

cmbemployeename.selected.value
cmbprojectname.selected.value
cmbemploc.selected.value

I know combo boxes went through a change recently so you’ll want to verify .Selected still works or if it should be .SelectedItems or something else. I believe .Value could also have changes to .Text too but basically validate your filter values and test again.
WarrenBelz 143,532 on at

Like (0)

Report

Re: Filtering Form component based on combo box

Hi @Mahesh005 ,

Firstly have you tried copying the form outside the Component and seeing if it works there - currently component access of data is still in the Ideas Forum (also refer to the specification document)

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.

MVP (Business Applications) Visit my blog Practical Power Apps