Hello,
I have a custom form/SharePoint list in which users can report application errors they're experiencing. They can also report other users who are experiencing the same error by listing their User ID in a field called Affected34s (34=UserID). I have a flow that duplicates this error ticket on said specified users. If the 34ID of the GetItems Item is included in the original TriggerEvent Item's Affected34s field, then it duplicates the error ticket on that affected user's item.
The list is too large, however, and performance is suffering (15 hour runtimes). I hoped to use Filter Query substringof(User34, Affected34s[Dynamic Content from Trigger Event]) but it seems you have to use an actual string in the first argument and not just the field name.
Anybody know of a way to achieve this? THANKS!!
