Power Platform Community Forum Thread Details

Hi ,

I'm relatively new to using logic apps / power automate , ive created the below logic app which essentially gets a few files in a sharepoint folder and uploads them to the same azure blob storage folder. Each of the files starts with the same prefix "1." how would i amend my logic app to look at the sharepoint folder , loop through and get all off excel files within it starting with "1." and upload them to the azure folder?

the reason i ask is more files are needed to be added to my logic app on a bi monthly basis therefore amending my app will help me to automate it. i have included a screenshot off my flow below .

Thanks

Categories:

Building flows

You don’t need individual actions or a For each loop. In a Logic App, you can turn on “Split On” in the trigger or in the SharePoint “Get files” action. When Split On is enabled and you pass the list of files, the workflow automatically creates one run per file—no loop block needed.
Steps:

Use Get files (properties only) on the folder.
Add a filter in the action: Name starts with 1.
Enable Split On on the next action (e.g., Get file content).
Set Split On to: @body('Get_files_(properties_only)')?['value']
The Logic App will trigger once per file and you can directly upload to Azure Blob without a loop.