InfoPath Dev

A user is developing an InfoPath form, that is published to a SharePoint form library in SharePoint Online. There is a person picker field, set by a form load rule (on condition the field is blank) to be the current user (using the username() function). When using the form this works fine and upon the form opening the current user's name ...

Thank you Hilary, that has worked perfectly.

 Hi Hilary, thanks for your response - and apologies for the delay in my response. Unfortunately changing the code exactly as you have written hasn't worked (and I've never edited XPath before so I can't figure it out). I have attached the form template. The code is on an action rule on the Access_Levels field (within the ...

 To close the above question - I found an alternate way of achieving what was required without doing what I was intending to do in my above question - the alternative negated the need to get things into a second repeating table.

 Here's the XPath for the Action Rule.   substring-after(xdXDocument:GetDOM("Retreive Access Levels")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Approvers/pc:Person/pc:AccountId[xdXDocument:get-DOM()/my:myFields/my:Systems_Access/my:System_Access/my:Access_Levels = ../../../d:Title], "\") 

I have a challenging requirement that I'm not even sure if it is possible. I'm using SharePoint 2013 and InfoPath 2013. I have a form library, that uses a browser enabled form to collect the following information: 'Standard' fields: user, line manager In a repeating table: System, Access Level, Approver Please note the approver ...

Here's a quick sample of what happens / should happen in each row: System --- Access Level --- Approver Selected --- Correct Approver SysA ----- Level A1 ----------- Andy -------------------- Andy :) SysA ----- Level A2 ------------ Andy -------------------- Alex :( Sys B ----- Level B1 ----------- Andy --------------------- Barry :( SysB ...

Hi, Using SharePoint 2013, on a browser enabled form that submits to a form library, I have a repeating table with three fields called System, Access Level and Approver. I have a SharePoint list on the same subsite which contains a list of Access Levels (single text), System (a lookup to a list called Systems) and their ...

 So I eventually realised the error was that my conditions in the substring-after formula were the incorrect way around - I of course needed to use substring-after(username(),"\") - and now everything works.

On further investigation the root cause of the problem is that function username() in the preview just contains a person's username whereas the published form contains i:0#.w|domain\username. Unfortunately using a substring-after function also doesn't solve the problem. I have added a new text box called current user and I need to make ...