Team Forms is thrilled to unveil an exciting new feature that empowers users to harness past form responses as a data source for other forms. This innovative capability transforms your form submissions into a dynamic, reusable database, streamlining workflows and unlocking new possibilities for data management within your organization.
What Does This Feature Do?
With this update, you can now tap into data collected from previous form responses and integrate it seamlessly into new forms. This closes the loop in your data processes, enabling you to create interconnected, context-aware forms that adapt to your team’s needs. Whether you’re looking to improve efficiency, ensure data consistency, or enhance user experience, this feature has you covered.
Example
Imagine your organization uses an equipment purchase form to log details such as equipment type, serial number, and purchase date. Later, when it’s time for routine inspections, you create an equipment inspection form. With this new feature, you can effortlessly pull data from the purchase form to populate fields or dropdowns in the inspection form—no need to set up a Power Automate to push data into another list. For instance, the inspection form can display a list of equipment serial numbers from past purchases, ensuring that inspectors select the correct item without manual data entry.
Is there any published articles/post on how to make use of this?
Hi Yors,
This new feature works exactly how the existing data-sources feature works with SharePoint lists, JSON files and Excel Online. For more information on this feature you can reference the article in the link below:
You will notice in the data-sources screen you will now see an option for "Form Submissions" in addition to all previously supported data sources. By adding this new data-source you can then access the previous submission data from a SharePoint drop-down menu (or within custom JavaScript). One part that may be a little trickier is response data is usually quite complex/nested when specifying a field to display in a label of your SharePoint drop-down you may need to specify a custom label (e.g. item.data?.name) as shown below.
