Hey guys,
I am new to Dataverse and just figuring out the best way to patch data with an Excel file to Dataverse.
What's working is to export the data of an entity as an Excel file, so I can update the entity within this file thanks to the Microsoft PowerApps Office Add In-Connector.
What I want now is to update multiple entities with just one Excel file. So I added a new sheet and then get the next entity with the connector. I can select the fields of the entity, but when I'm done I only have an empty table to this entity. I am not able to get the existing data of this entity from Dataverse.
So I wonder is this even possible or do I need to have an Excel file for every entity? Or am I missing something to get the data?