Browser Forms

Re: Action rule in repeating table not working correctly

bkwhodgson — Thu, 04 May 2017 08:00:03 GMT

Thank you Hilary, that has worked perfectly.

Re: Action rule in repeating table not working correctly

Hilary Stoupa — Tue, 02 May 2017 14:20:53 GMT

Try this: substring-after(xdXDocument:GetDOM("Retreive Access Levels")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Approvers/pc:Person/pc:AccountId[current() = ../../../d:Title], "\")

Re: Action rule in repeating table not working correctly

bkwhodgson — Tue, 02 May 2017 09:34:55 GMT

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 repeating table).

Thanks for your help,

Re: Action rule in repeating table not working correctly

Hilary Stoupa — Tue, 07 Feb 2017 15:44:11 GMT

Again, you probably need to be using the current() function in your XPath - feel free to attach your form in a reply under the options tab if you'd like me to take a look.

Re: Action rule in repeating table not working correctly

Hilary Stoupa — Tue, 07 Feb 2017 15:43:24 GMT

Sorry I was so slow to reply, I didn't notice you'd responded till someone else posted in the thread - I think you'll need current here in here someplace - without knowing where the rule is, I'm guessing: substring-after(xdXDocument:GetDOM("Retreive Access Levels")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Approvers/pc:Person/pc:AccountId[current()/../my:Access_Levels = ../../../d:Title], "\")

Re: Action rule in repeating table not working correctly

Arthur.Avanesyan — Tue, 07 Feb 2017 05:44:17 GMT

I have similar problem. When I apply filter in the repeating table, values that are in top of the secondary list are selected. Not with the highest ID, but by sorting. My secondary data is sorted by country names in ascending order, so if I select Finland, Belgium, then Algeria, all rows are displaying correctly filtered values. But if I select Algeria, Belgium, Finland etc., then all rows get Algeria's values.

Does anyone found solution on this?

Re: Action rule in repeating table not working correctly

bkwhodgson — Fri, 27 Jan 2017 16:50:18 GMT

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], "\")

Re: Action rule in repeating table not working correctly

Hilary Stoupa — Wed, 25 Jan 2017 20:35:44 GMT

It sounds like an issue w/ your XPath filter. If you click "Edit XPath" for the formula you are using for the value, what's the full XPath? Just paste it in a reply.

Re: Action rule in repeating table not working correctly

bkwhodgson — Mon, 23 Jan 2017 16:52:53 GMT

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 ------ Level B2 ------------ Bill ----------------------- Bill :)

SysA ------ Level A1 ------------ Bill ----------------------- Andy

It seems to be that the repeating table selects the same as the first item / preceding row, until it comes across "Bill", then all future rows are populated with "Bill". The only significance of that that I can think, is in the Access levels table the last entry - the one most recently created (therefore with the highest ID) is the access level with Bill as the approver - it's as if it can't find a match and therefore goes for the access level with the highest ID and selects its approver.

Hope this helps.

Action rule in repeating table not working correctly

bkwhodgson — Mon, 23 Jan 2017 16:33:54 GMT

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 approvers (person picker field) - I am retrieving this list as a data connection.

Firstly the Access Level field is filtered to only show the access levels that belong to a particular system (i.e. cascading dropdowns) - this works fine. The Access Level field has an action rule which set's the value of the field Approver to the outcome of the following function: substring-after(AccountId[Title = Access Levels], "\"). AccountID is from the Access Levels secondary data connection that's part of the person picker group of the "Approver" column. The filter, although it says "title" when I click further and see the filter, it is filtering based on the Access Level field from the repeating table (part of the "Main" data connection) and the access level field from the secondary data connection to the Access levels SharePoint list.

The problem is that the first item in the repeating table seems to work OK (at least when it is first entered) as it retrieves the correct approver, but any additional rows don't retrieve the correct approver. Plus, if I edit the first row and change the access level the approver also becomes incorrect.

I haven't narrowed down any consistency in which approvers are being picked - sometimes it seems to be the user from row 1 that is selected in subsequent rows, but not all the time.

Can anybody help?

Thanks.