SharePoint doesn't search by the ID column of a list. I am using the ID column as the "number" for a ticketing system.
I tried to use a calculated field to that just showed the ID column value, but you can't use the ID in a formula.
I can use a Power Automate to update a text field with the ID column, but that will count as a "modification" of the item and thus result in another flow sending out an email to the users.
What method does Plumsail use for such a problem?
Do you generate your own ID?