I am hoping someone can please help me!!
I have multiple sharepoint lists that departments update during a project cycle, I want to pull the data from each list into a central database so all areas can be across the project at once.
An example of how I would like this to work is:
- Base project information - Project name, cost codes and project manager
- Project management - status of project with links to documents and other items
- Stakeholder - stakeholders communications, calendar and other important updates
- Budget - budget milestone dates and figures.
- All information - all information from above
- Base project information added - flow to add items to all other lists (this I have completed)
- update information - any item update will have the follow-on effect to all information lists (12 lookup tool error)
When I create my flow I get an error stating that there can only be 12 lookups. Is there a way around this or what kind of fields do I need to use? This will be a large database so we will have over 150+ fields.