InfoPath Dev

Thank you very much. I did some small mistakes but finally I made it and its working fine. Thanks for you help. I need some other help below is my output. I have changed the repeating table data connection with REST web service. Now the drop down lists are not working(I created drop downs with sharepoint list data connection) how can I use REST ...

..

Now I am not getting any errors but filter is not working on Infopath

I used https://[server]/dor/OCG/_vti_bin/ListData.svc/Equipment_federal?$filter=substringof('", EquipmentSearch, "',DESCR) eq true

I am getting this error. But am able to retrieve XML data from the URL

I Used this formula concat("https://[server]/_vti_bin/ListData.svc/Equipment_federal?$filter=substringof('", DESCR, "',my:EquipmentSearch) eq true") and its working fine and the URL also fetching XML data when I opened in a browser(https://[server]/_vti_bin/ListData.svc/Equipment_federal). The form fetching data with ...

I have changed the fields in the formula first I Used DESCR and then EquipmentSearch. Now I am not getting any error but the filter is not working. I have added Change REST URL and Query Data to the submit button.

Here I attached my form Thanks,

Error: Expected value type: , concat("https://share.uh.edu/dor/OCG/_vti_bin/ListData.svc/Equipment_federal?$filter= substringof('", my:EquipmentSearch, "', tolower(xdXDocument:GetDOM("-->Equipment_federal

I have used this formula and selected fields using field picker. concat("https://[server]/_vti_bin/ListData.svc/Equipment_federal?$filter=substringof('", EquipmentSearch, "', tolower(DESCR)) eq true") Where EquipmentSearch is textbox name selected from MAIN data source and DESCR is selected from query fields of ...