Hello,
What I am trying to achieve here is fetch the data from mail and process it for PowerBI Dashboard.
Data is scheduled report coming as zip file with name as date/month string and extension as csv.
So I created Flow where
1. When a mail arrives, the attachment (zip) file is taken,
2. Create a file with Attachment content to Extract Folder in OneDrive for Business,
3. Extract the archive (zip) in another Folder called Source.
4. Rename the file to static name so that it could be overwritten and pulled by PowerBI for data processing.
Upon testing, i am encountered with error that states -
"ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_3')?['Name']' is of type 'String'. The result must be a valid array."
I am attaching my Flow here,
Apply 2,
Error
Flow continued
HI @gtuser
Your reasoning is correct, but you're trying to do a "for each" that gets an array and parses the values, but you're supplying it with a string (Name). You don't need that extra "Apply to Each."
Join digitally, March 2โ4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
34 | |
15 | |
15 | |
13 | |
7 |
User | Count |
---|---|
42 | |
32 | |
25 | |
12 | |
12 |