Looking for advice on an O365 Query List workflow.
Basically I'm looking up a table on another site and returning a value.
This has been working but not consistently.
I'm finding I'm getting an exception occurred while processing request. correlation id error or the workflow just sits as started and not moving on. I've I add a preceding action to log to list for example "about to start query" that's all I see when looking at workflow history.
Is there best practices to implement this query regarding performance?
Should I be using the list ID as apposed to the list name?
What about SharePoint online URL\site URL? Should they be the same?
Just wanting to get feedback on other peoples experience using this workflow.