Hi Power Platform Community! 👋
We are working on a data sync project at our company, and we’d love some advice on best practices.
Transforming Data Before It Hits SharePoint:
We often need to transform or filter data before it gets sent to SharePoint. For example:
Doing this kind of data transformation mid-flow feels complicated, and we are struggling to figure out the best way to implement it efficiently.
How Should We Structure These Syncs?
We’re not sure if it’s better to:
We’re aiming to build a reliable solution that accurately reflects all changes made to the Excel Census across Dataverse and SharePoint without reloading entire lists every day.
Thanks so much for your help! Any insights or recommendations are greatly appreciated.