Power Automate error

Question

Hello,

After some time runing this flow it begin to present two errors.

The first one is regarding the number of the itens that are being check in the list.

Today the list has 122 IDs but the flow stop checking them on the ID 100. I already check the sharepoint view and it is marked as "all itens", so it sould be a something in my flow.

The second problem is regarding the below error. Only some items of the list happens to have this error. I already check the date of the items o sharepoint and there is nothing wrong.

Did someone already have this errors before?

Answer 1

The flow issues come from two different causes: how the items are being retrieved, and a data-type mismatch in an expression.

1. Items stopping at ID 100

• This is typically caused by how the SharePoint items are being retrieved (for example, a default page size/top count, or a filter/order that only returns part of the list), not by the SharePoint view.
• In the flow run history, open a failed/successful run and inspect the output of the action that gets items from SharePoint. Confirm how many items are actually being returned and whether any filter or Top Count is applied.
• If pagination or limits are configured in that action, increase the threshold or enable pagination so that all 122 items are returned.

2. Error “The template language function 'less' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.”

• This means the expression using less() is comparing two values of different types. For some list items, the value being compared is null (for example, an empty date column), while the other is a string.
• To fix this, adjust the expression so both parameters are of the same type and handle nulls explicitly. For example:
  • Use a condition to check @not(equals(<yourField>, null)) before calling less().
  • Or convert both values to the same type (for example, both to numbers or both to dates) before comparison.
• Use the flow run history:
  1. Go to My flows.
  2. Open the flow and select a failed run in the 28‑day run history.
  3. Open the failed step (the action where less() is used) and review the Inputs and Outputs to see which field is null for those specific items.
  4. Update the flow to guard against null values or to ensure the column is always populated before comparison.

After making these changes, run the flow again and monitor the run history to confirm that all items beyond ID 100 are processed and that the less() expression no longer fails for items with empty values.

---

References:

• Troubleshoot a cloud flow
• Troubleshoot cloud flows
• Find and fix errors with flow checker
• Flow Runtime errors and recommendations

Answer 2

Hi @Karla Pereira, 

Thank you very much for reaching out and for providing the details about the issues you're experiencing in your Power Automate flow. I understand how important this automation is for your work, and I appreciate the screenshots and explanation you shared. 

Based on your description, the behavior you are encountering appears to be directly related to the configuration of expressions and the way certain data values (such as null or mismatched types) are being handled within Power Automate.  

Since my support category mainly focuses on general Office 365 topics, and your scenario involves Power Automate flow logic, advanced expressions, and SharePoint data processing, it falls outside the scope of what I can fully troubleshoot in this area. 

To ensure you receive the most accurate and dedicated assistance and to avoid any misunderstandings or delays. I strongly recommend posting your question in the Microsoft Power Automate Community, this is a dedicated channel for Power Automate discussions. In the Microsoft Power Platform Community Forum, you’ll find the most qualified group of respondents, and other partners who regularly read the forums can share their knowledge or learn from your interaction. 

I hope this information is helpful. Should you have any further questions or need additional assistance, feel free to reach out.    

Thank you again for your understanding and cooperation. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".  

Note: Follow the steps in our documentation to enable email notifications if you want to receive email notifications related to this topic.