Hi @Rohit Kulkarni ,
Thanks for your query. I believe something wrong with the path provided in the ADLS dataset of Get Metadata activity.
Below path looks confusing. Not sure why a JSON array object is passed in the dataset path. Have you configured this or the path was populated by dynamic expression? Could you please confirm ? If you are using a dynamic expression to populate the path in dataset, please make sure that the expression is correct and it returns a valid path as expected.
It seems like that JSON object in the path looks like an output of a Lookup activity. In case if you are trying to form the path like GPO Corp 2017/Companies/Group O/Acc_ Sched_ Cell Value
then you should have this Get Metadata activity inside a ForEach activity, where under settings, the items = @activity('Lookup1').output.value
Then your dataset path expression should be like : @concat('GPO Corp 2017/Companies/Group O/', dataset().ds_param_folder)
Where dataset().ds_param_folder
is the dataset parameter which maps to the current item
of the iteration as below .
And dataset path setting looks like below (this is just a sample for reference)
Hope this helps.
----------
Please don’t forget to Accept Answer
and Up-Vote
wherever the information provided helps you, this can be beneficial to other community members.