InfoPath Dev

No - I'm sorry, there is not. This is one of the limitations of SharePoint list forms.

Yeah, I've actually seen this happen before, where Title is blank. Are you using SharePoint Online? Or is this an on-prem server? You may be able to use an OData connection to the list if this is on-prem, and then you would be able to get more information back in your query (and I can give you more info on that, if it sounds like it might work ...

Maybe try this one. Save the attached file locally (right click the link in the post header, select the option to save the file, then find the saved file, right click and select Design to open in InfoPath Designer). From there you can preview, select a province and see if the right (or any) items show in the Hibou dropdown...

 Of course! Thanks again for taking the time to look at this.   I believe i'v added the right field "province" Under Hiboux3. Please tell me if it's right.   Thanks! 

thank you Hilary.. I retry again and now this time it actually worked. just needed some extra patience :) thank you so much

Glad you have an approach that works for you! :)

Thanks Hilary, much appreciated. I used a hybrid system for my form using what you sent me and what I've already created. The way you use the Calculated field was new to me.

Well - that screenshot doesn't seem to show the new table / controls I put on the form? Did you preview and try those? Where you don't need a bunch of description fields with conditional formatting?

I have a data connection to a document library, and I want to populate the dropdown with the name of the documents that are currently in the actual library. However, I am only getting the folder names to appear. I tried creating a stripped down version of this library with only the documents, no folders and I am still unable to get the ...

Hi Hilary, I went ahead and tested what you shared with me. It seems to be giving the same output. see attached image.