Share
Report
193Hi all,
I currently have a canvas app (a custom page in a model-driven app) where I have given users the ability to attach a specific excel template file for the purpose of parsing the data and creating new rows in Dataverse from the table within. I have achieved this by following recommended method that other users have written about on here: Upload the file, saved the data as a datastream, then an automate flow creates a file in SharePoint using the datastream (uritobinary conversion, etc). Then I grab the rows from that new table to recreate data in Dataverse.
It works well, though my PowerFx function suddenly started giving an error (unrelated) so I wanted to go back and try and streamline the functions in this app. I am wondering if there is a way to get these results without having to create a file in SharePoint, meaning either parsing this data directly within the app or within the automate flow. For my apps, it is best to avoid having to use too many connections that could potentially run into errors in the future (if someone removes the SharePoint library, or the SharePoint site altogether, since it is a Team site.)
All responses (
Answers (
