InfoPath Dev

Not without code or third party tools like qRules / FormsViewer. InfoPath doesn't natively expose that information - it stores the attachment as base 64 in the XML for a library form, and when it displays the file name, it is reading it from that base 64.

Hi, So I tried your method for the User Information List and it works! Thank you! I have attached my file here, So yesterday I tried creating a site just for the forms (5 companies = 5 parent site each site have 4 forms) and tried to submit the form it works! Because previously all of the forms are under 5 subsites with 1 subsite have 4 forms ...

 Thank you for your quick response. Let me try it out. Thanks, :)  By the way, is it possible to get the same solution for the InfoPath document library as it does not appear the attachment URL like the list? How can I make it work? Any suggestion is greatly appreciated.  

I think you could use substring-after(substring-after(URL Field Here, "https://eddnet/sites/TestSite/Lists/TestRequiredFields/Attachments/"), "/")

 Hi Hilary,  Sorry, other post is slightly different because I realized that the InfoPath form for other post is using the Document Library, which somehow it does not appear the attachment URL as same as the list. Therefore, I was only able to display the attachment URL on the ...

 I'm guessing this is related to your other post - what does the URL look like? This must be a SharePoint list form, right? So the URL will have the item's list ID prior to the name? What's a sample URL?

Hi, My InfoPath SharePoint list has a file attachment and I am able to display the attachment URL in a separate text field after a file attached. I wonder if there is a way to use a concat (substring-before(My URL), substring-after (My URL)) to get a file name of the attachment to be displayed in the text field, is it possible? Any ...

For the User Information List, if you set the Account query field to the value from the userName() function in InfoPath, then run the query, you will get the data for the current user. Please note that userName() returns a different value in Filler vs. the published browser form - so you'll need to test in the browser.

Can I see your form? You can attach it under the options tab in a reply. For the User Information List you should be able to use a query field - set to the value of the current userName() - I'll go figure out which query field to use for that - then run the query. Is the User Information List the only query that causes the error?

Thanks a lot. It worked.