Table and Field Architecture on the Power Platform
![](https://cdn.dynamicscommunities.com/wp-content/uploads/2021/11/Table-and-Field-Architecture-on-the-Power-Platform.png)
There are many different ways to store and relate your data in the power platform, but each have their own consequences. Should you use an option set, a lookup, or a “two options” column? Should you relate many-to-many entities with an N:N relationship, a custom intermediary entity, or the “connections” feature?
In this session, we’ll discuss the best architecture for various common scenarios, how your choices may affect automations/reports/scripts, and how to future-proof your data.