Search - InfoPath Dev Sign in | Join | Help 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 Search More Search Options Page 2 of 2 (18 items) < Previous 1 2 Re: Look up data from sharepoint list Hi, all working!! Many thanks for your support and great help. Kind Regards Dave Posted to General (Forum) by davedmonds on 02-02-2015 Re: Look up data from sharepoint list Posted to General (Forum) by davedmonds on 02-02-2015 Re: Look up data from sharepoint list Here you go xdXDocument:GetDOM("Mileage return data")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:o7i7[(../d:submitter = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Driver0/pc:Person/pc:DisplayName) and (../d:kxwq = ... Posted to General (Forum) by davedmonds on 02-02-2015 Re: Look up data from sharepoint list Hi, I am all set up until the [last()] function, It keeps evaluating to an error. Can you give me an example of how to insert it please? Dave Posted to General (Forum) by davedmonds on 02-02-2015 Re: Look up data from sharepoint list Hi, thanks for this, I will give it a go. Just so I know, would it be an applicable method for 2 step data validation. As some drivers use more than one vehicle, it will be necessary to match not only the username but also the registration number. Thanks Dave Posted to General (Forum) by davedmonds on 02-01-2015 Look up data from sharepoint list Hi, I have created a sharepoint list linked to an embedded InfoPath form foro ur drivers to submit monthly mileage returns. When the form loads, I would like it to load the drivers end mileage from the previous submission and to load it for the start mileage of the new submission. I know how to perform a simple "vlookup" ... Posted to General (Forum) by davedmonds on 01-30-2015 Email submission Hi, I have my form created and the email submit button set up. In preview it works like a dream. When published it evaualtes to an error. The error is to do with the email address. I have cut the email address out of a longer string ( I have a hidden field that shows me the substring is correctly formatted). Why would this become an error when ... Posted to General (Forum) by davedmonds on 09-08-2014 Re: Concat string help [SOLVED] Hi I wonder if you would be able to point me in the right direction for copying just the email address out of a string in the following format: i:0#.f|membership|12345@example.com Cheers Dave Update, I used the following code to achieve the desired result: substring-after(temp email, ... Posted to Controls (Forum) by davedmonds on 09-08-2014 Page 2 of 2 (18 items) < Previous 1 2 Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.