Hi everyone.
I am new to power automate and i am struggling with creating a specific flow.
I have a power bi report that looks at monthly performance data. The report is using a number of files currently on a onedrive folder. Each month a new set of files are created. I need to move these files to another onedrive folder. However, the files names are made up by a main part of the name followed by a PXX (where XX represent the month number). For the BI report to work, i need to move the files to another onedrive folder and removing the PXX part of the name. I have been doing this manually, but would like to move to a power automate flow that is triggered manually by me.
I have successfully done this other files where the name was not dynamic by using the below flow. This flow for obvious reasons does not work when the file name is dynamic. Can anyone help me with a flow that would do the same but taking into account that the file names are dynamic. The onedrive folders are static.
