
Announcements
Using the virtual connector (set up here: https://docs.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/create-virtual-tables-using-connectors?WT.mc_id=BA-MVP-5000177&tabs=sharepoint#create-the-connection) with a table being referenced in Excel, I get this error, "String primary keys are supported only if they can be parsed as GUID." What do we need for a primary key in an Excel table. Does it need to be unique?
For example you can add a new column inside your excel and use this kind of formula to generate a random GUID https://stackoverflow.com/questions/14990236/how-to-create-a-guid-in-excel
hope it helps