Passing the sum of total in subsite to another list

Discussions about Cross-site Lookup
User avatar
Posts: 107
Joined: Tue Oct 24, 2017

05 Dec 2018


I have two lists.

2.Absence. (In a sub-site)

What I want to do is take the total of a field called “daystaken” in the absence and apply the sum of the total to a field called “Absencetotal” in the personnel list. Criteria: Where the employee_name of both lists are the same AND where the “Daysold” field in the Absence List is less than 365. Then run this on a timed workflow.

The problem is, I believe I cannot run a workflow with subsite and site. Therefore I was wondering if this was possible within the cross-site lookup functionality?

User avatar
Posts: 232
Joined: Mon Aug 27, 2018

06 Dec 2018

Dear Roo,

I'm not quite sure how to implement this functionality using Cross-Site Lookup, but let me suggest alternative ways:

1) Workflow Actions Pack: ... caml-query
2) JSOM: ... sharepoint

  • Information
  • Who is online

    Users browsing this forum: No registered users and 2 guests