The video title is intriguing. The points are very true! What are your thoughts on using a guid() function as a foreign key? I'm using it for some of my powerapps that needs a sort of relational database because the caveat is the org doesn't want to spend money on premium features. So to achieve that without dataverse, I implemented an item-level permission using some of sharepoint api via flow.
Using GUID() as a foreign key in PowerApps is a viable solution for creating relational-like structures when premium features like Dataverse are not an option. It provides uniqueness and consistency, though you should be mindful of readability and performance considerations. Implementing item-level permissions via Power Automate flows further enhances security and access control, aligning well with organizational requirements and constraints.