General

Re: Look up data from sharepoint list

davedmonds — Tue, 03 Feb 2015 17:19:31 GMT

Hi, I did that too, turns out there was a hidden rule sitting in the form load section that was confusing a field change rule. My bad sorry.

Thanks a lot.

Dave

Re: Look up data from sharepoint list

Hilary Stoupa — Tue, 03 Feb 2015 16:56:49 GMT

I removed the submitter manually from this one:

xdXDocument:GetDOM("Mileage return data")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:kxwq = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:kxwq][count(xdXDocument:GetDOM("Mileage return data")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:kxwq = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:kxwq])]/d:o7i7

Re: Look up data from sharepoint list

davedmonds — Tue, 03 Feb 2015 16:49:20 GMT

Hi, we have a change to make!! sorry. I want to remove the matching of the driver name and only validate on registration number if possible. I tried to edit your xpath code but it messed up some rules on other fields.

Could you explain how I can edit this xpath to remove the driver matching?

Re: Look up data from sharepoint list

davedmonds — Mon, 02 Feb 2015 16:40:52 GMT

Hi, all working!!

Many thanks for your support and great help.

Kind Regards

Dave

Re: Look up data from sharepoint list

Hilary Stoupa — Mon, 02 Feb 2015 16:24:49 GMT

Oh euw. I forgot a browser form won't support last. Let's try with a count of the rows.... Are you using query fields to only return the rows you need? If so, we may not need the filter on submitter and kxwq.

xdXDocument:GetDOM("Mileage return data")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[(d:submitter = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Driver0/pc:Person/pc:DisplayName) and (d:kxwq = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:kxwq)][count(xdXDocument:GetDOM("Mileage return data")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[(d:submitter = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Driver0/pc:Person/pc:DisplayName) and (d:kxwq = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:kxwq)])] /d:o7i7

Re: Look up data from sharepoint list

davedmonds — Mon, 02 Feb 2015 15:58:02 GMT

Re: Look up data from sharepoint list

Hilary Stoupa — Mon, 02 Feb 2015 15:53:36 GMT

Try this:

And if you get a syntax error when you verify, let me know what it says (you can attach a screenshot under the Options tab in a reply)

Re: Look up data from sharepoint list

davedmonds — Mon, 02 Feb 2015 15:45:33 GMT

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 = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:kxwq)]

It has 2 step verification using Driver name and Registration number.

Dave

Re: Look up data from sharepoint list

Hilary Stoupa — Mon, 02 Feb 2015 15:39:58 GMT

What is the error you are getting? Can you select the edit XPath checkbox in the formula editor and paste it in a reply?

Re: Look up data from sharepoint list

davedmonds — Mon, 02 Feb 2015 09:57:01 GMT

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

Re: Look up data from sharepoint list

davedmonds — Mon, 02 Feb 2015 07:49:55 GMT

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

Re: Look up data from sharepoint list

Hilary Stoupa — Fri, 30 Jan 2015 22:43:56 GMT

Hi -

Let's see. I think what I would try is:

Create a data connection in the form to the same list the form submits to.
Make sure the form submits the userName() to a field - like, I'd add a field called "Submitter" and then on form load, if submitter is blank, set it to userName().
Select whatever you use to identify the driver (maybe name if that is unique) as one of the columns - it would be great if you had their user name in the list, because then you could easily get back just the items for "this" driver.
Select "Created" or "Modified" (whichever date you think will let you know if the submission is "most recent" - probably "Created"?) and be sure to sort by that field, so the data is returned date ascending
Set the data connection to NOT query on load (this is a checkbox on the final screen of the dialog).
When the form loads, set the Submitter query field in the DC created in step 1, and execute the query - this should return all the rows for this submitter from oldest to newest.
To set your field's value, you'd select the field in the data source that has the mileage, then add a [last()] XPath filter to it

It sounds harder than it is - post back if you need help. :)

Look up data from sharepoint list

davedmonds — Fri, 30 Jan 2015 11:52:02 GMT

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" type action when loading a form however this will obviously be a little more complex. Does anyone have a suggestion as to how it can be achieved? I am a novice user so programatical answers may be lost on me.

Thanks a lot.

Dave