Table and Field Architecture on the Power Platform

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.