Power Platform Community Forum Thread Details

Issues in Power Automate Flow for File Categorization in SharePoint

Description:
I have a SharePoint document library where I need to categorize files based on predefined category keywords. My Power Automate flow fetches file names, matches them against keywords, and then updates the category in SharePoint. However, I am facing two issues:

Issue 1: Inaccurate Keyword Matching

I am using a loop with the contains() function to check if a filename includes a category keyword.
The function is not working 100% accurately, and some files remain uncategorized even when they contain matching keywords.
I need a 100% accurate method to match keywords within filenames.

Issue 2: Batch Request for Updating Categories Fails

I am using Power Automate Batch Requests to update file categories in SharePoint.
The batch request fails, and the category is not updated.
I need a working batch request implementation to update multiple files efficiently.

Expected Outcome:

Accurate keyword matching in filenames to ensure correct categorization.
Successful batch request execution to update the SharePoint document library with the correct categories.

Steps Taken So Far:

Implemented loop with contains() function for keyword matching (not fully reliable).
Tried Batch Requests for SharePoint updates (not working).

Request for Assistance:

What is the best way to accurately match keywords in filenames?
How can I correctly format and send a batch request to update file categories in SharePoint?