Combine data from different SharePoint Lists
Vladi Gubler
Vladi Gubler
May 02, 2018 | Products

Hi,

Great news: Ultimate Forms is growing and we are adding more features. Our Smart Rollup Pro, up until now a stand-alone component, has been incorporated into Ultimate Forms and will now be available to our customers as a part of the suite.

Smart Rollup Pro existed as a stand-alone component and was available on premises only. We have developed an Office 365 version that has been added to the Office 365 edition of Ultimate Forms. On premises, Ultimate Forms Enterprise customers will now receive this component included in Ultimate Forms.

Smart Rollup Pro allows you to display a unified view of items from different lists across a site, site and its subsites, or the whole site collection. You start by specifying a template list and view. That view will instruct us what fields the aggregated lists should contain and what is going to be the order of displayed columns in the component. You can also specify if you want to use any of the view's filters (for example, your view might only show open tasks, you can use that filter for all the items we collect across your site collection). You can also provide additional filters, together or instead of the view filters.

Next, you will create one or more data sources. You can select the site from which to start and the lists you want to include. You can select lists of certain type, based on a certain template (such as Contacts or Tasks) or even select specific lists by name. You can fetch the lists from just one site, from a site and all its subsites or from the whole site collection. You can actually specify multiple data sources (for instance, if you want to collect data from 2 or more specific sites, but not include any subsites).

It is important that the lists you fetch are similar to the template list. At the minimum, they must contain all the fields present in the template view, otherwise the list data won't be loaded.

Smart Rollup Pro is a great and efficient tool for bringing all your items, spread out throughout your sites, into one place. Once loaded, the items can be viewed, edited or deleted from a single location.

In Office 365, you must use the latest version of Ultimate Forms Extensions for Modern UI to be able to use the component.

Loading...

Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.

UltimateForms

Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!

Cost-effective

Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com

Related Topics

What is right for you?

Online Trial

Not ready to install yet? Create a trial site in our environment
  • Full control of the site and its settings
  • Optionally pre-install one of our solution templates
  • Site provisioned instantly
  • Automatically removed after 30 days
  • Available to everyone!

Error!

There was an error processing your request.
Please contact us for further details.

Installation

Install in your own environment, on Microsoft 365 and on premises
  • Start working with real users and data
  • Install online or on premises
  • Register for 30 day trial
  • Seemlessly convert to paid license
  • Requires administrator permissions

Success!

Download link has been emailed to .
If you do not receive it within 5 minutes, please check your spam.
The link is valid for 72 hours.
If you are having problems, please contact us.

Error!

There was an error processing your request.
Please contact us for further details.
Technical details:

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.