Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Dynamic Content in BOTH Arguments of Substringof() Filter Query

(0) ShareShare
ReportReport
Posted on by 67

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!!

 

alexleetoo17_0-1653050657964.png

 

 

  • Verified answer
    alexleetoo17 Profile Picture
    67 on at
    Re: Dynamic Content in BOTH Arguments of Substringof() Filter Query

    found the answer in a variable

    alexleetoo17_4-1653061646272.png

     

  • alexleetoo17 Profile Picture
    67 on at
    Re: Dynamic Content in BOTH Arguments of Substringof() Filter Query

    alexleetoo17_0-1653051389849.png

    Should've included the error screenshot

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,587 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,928 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow