Passing the sum of total in subsite to another list

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

05 Dec 2018

Hi

I have two lists.

1.Personnel.
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
AlexZver
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: https://plumsail.com/docs/workflow-acti ... caml-query
2) JSOM: https://docs.microsoft.com/en-us/sharep ... sharepoint

Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 2 guests