Hi all, i am trying to build a flow to copy excel files from one drive to share point folders which are located in different share point sub sites.
I am trying to use switch function but all files are going into only one folder in a sub site that i included under default branch of switch control.
Please see below the flow.
Regards,
PW
Hi @RV_KONDRA
The data returned is encoded.
Try the following.
The Name property from "Get file metadata" will have your file name so you can use it in Switch.
Note: the Name will also have the file extension.
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
Hi Riza, thanks for the response. But still, it is copying all files into default branch of the switch control.
Below is how i tried in switch control.
When the flow is running, you can check the value of the compose action.
See if that value exactly matches one of the cases that you have provided.
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
Hi Reza, you are right the excel reports in one drive have below file names. So is it we need to get compose with current date-name of the company - report name.xlsx
Hi Reza, i think it is reading the correct value. Please see below screen shot.
That is correct, you would need an exact match
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
Hi Reza, i got for each company 4 to five reports with different dates and report names something like below. So it we need to create 4 to 5 compose expressions?
User | Count |
---|---|
93 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
49 | |
46 | |
30 | |
25 |