web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Writing to multiple li...
Power Apps
Unanswered

Writing to multiple lists from one input

(0) ShareShare
ReportReport
Posted on by

Good morning,

 

I'm working on developing a quality assurance app related to interactions with our members, and other audits. Because of the number of criteria we have (upwards of 120 at the moment, with a further review likely to have more) and the requirement to have 'blank' columns to allow room for new criteria to be added, multiple SharePoint lists will be used.

 

Because of this, the columns with identifying data for the review (e.g. consultant, reviewing agent, time and date of call etc) will be the same across all lists so I essentially need to take the input from one datacard and save it to multiple lists.

 

I also need to be able to record data from the one form spread across multiple lists depending on where the criteria is housed. For example, correct identification criteria may be on list 1, while accurate communication criteria may be in list 3 but will need to be input from the one form for one interaction.

 

I've only worked with one list before, and haven't really investigated or made use of collections, but I'm wondering if they are something that would assist here, or if anyone has suggestions on where I should start?

 

Categories:
I have the same question (0)
  • BhargavPatel Profile Picture
    660 Moderator on at

    @Farsie Instead of making your tables wide (lots of columns) make them tall (lots of rows) by designing relational (parent-child) database. Here is video by Daniel Christian that will help you understand the concept. The concept you are using is not the best method, because you will end up lots of duplicate data and that can lead to data integrity issues if the repeating data (consultant, reviewing agent, time and date) for a given record don't match in all different lists. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard