I cannot figure out how to get a file into the format required for the new upload files activity to work. I have got the “classic” to work which uses an azure app etc. but I need the new activities that leverage connections.
I cannot figure out how to get a local file, such as an excel etc. into the required format to upload using these activities. The classic upload tool was easier and worked just fine but my security team does not like issuing azure app access so using the credentialing tool is preferred.
My studio is 2023.4.1
Microsoft 365 package is 2.2.3 (released on 06/16/2023)
It needs an i local resource and as of now…to get an ilocalresource we need to use path exists activity…which has an output type of iloca resource which can be used as input to upload files activity
It should be a datatable…with teo columns first being the display name of the metadata column you want to set and second column will contain the corresponding value