Power Platform Community Forum Thread Details

Issue with apply to each steps not detecting keywords resulting in wrong condition evaluation

Hello Friends,

I was wondering if someone could help me with a flow issue.

I have a flow that automates detection of keywords from uploaded files (using AI builder( & flag them in a SharePoint Document library

This is what the flow does in a nutshell :

Users submit Students Profile documents in SharePoint
Upon upload, an automated process (Used the text recognition prebuilt model in Power Automate )scans the document for keywords/phrases stored in the SharePoint list "Keyword Identifier."
If any keyword is found, the document is flagged in the SharePoint library Students Profile with:
- "Keyword Identified" (Yes/No)
- "Keyword " (list of matched keywords)
- “Keyword Check Flag” (Yes/No)
The process runs every time a document is uploaded.
Coverting the keywords and pdf content to lower case to avoid case insensitivity,

The issue I have is 1) It needs to match exact keyword whatever i do expression returns false.

Apply to Each (loop through the keywords):
- Condition (Check if DocumentContent contains Keyword):
  - contains(trim(toLower(variables('DocumentContent'))), trim(toLower(item()?['Keywords'])))

If true, set a flag (or log the match).
Please suggest what mistake im doing here and also if any alternative option to do this. Library has huge document inflow with more than 5000 a day in a week.
#AI #Powerautomate#PDF scan