cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stanford
Frequent Visitor

Variables when subject contains Item ID Number

Hi Folks,

 

I'm building an ICT Help Desk for my organisation - So far I've created the flow 'When an email is recieved in a shared mailbox - create an item in sharepoint' and also 'when an item is modified in sharepoint - contact the email of the person who created the ticket to let them know.

 

Now the real problem I have is if I have a discussion over email regarding a ticket - every reply the end user makes will create another ticket with the subject and body of the email as the title and description of the ticket. 

 

I have tried to create variables where if the ID number of the ticket is in the Subject field then to not create an Item - my attempt hasnt worked so I shall show what i've tried to do down below. 

Capture.PNG

 

If anyone has any fix/suggestions that would be grand.

 

Many Thanks - Leon

4 REPLIES 4

@Stanford 

Hi there!  I think you're on the right path...just need to finesse the thing into working as you intend.  I'm not sure if your screengrab was from before you were finished with the Flow, but your condition might be missing the ticket number, right?20190716a.PNG

Keep us posted.

-Ed-

 

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Thanks for the prompt reply - 

 

So yes I did input the ID tag there as I have screen captured but I do get a flow failure which completely confuses me.

 

I will attach both screenshots below - many thanks for your help and support so far 

 

Flow with ID tag in conditionFlow with ID tag in conditionflow failure messageflow failure message

Ah, ok so it's yelling at you because it wants a String and you're giving it a number (integer).  So we need to convert that somehow from Flow's perspective.

One option might be to initialize another (String) variable at the top of the Flow, and then inside the Apply to Each (above the criteria), Append the ID to that variable (I don't think a Set will work immediately in the loop...if it does, cool.  Otherwise try Append).  Then use that string variable in the condition instead of the SP ID field.

 

Maybe Compose would work, too, but I'm not familiar enough with that.

Keep on truckin'

 

-Ed-

 

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Hi Ed,

 

Thanks for your reply - I'm completely lost at this point so I've tried to look into strings etc to see if I can implement them anywhere, so far this is what i've created but I'm not sure if I can paste this into a variable or function.

 

@or(
 contains(triggerBody()?['Subject'], 'Re'),
 contains(triggerBody()?['Subject'],'FW'),
 contains(triggerBody()?['Subject'],'Fw'),
 contains(triggerBody()?['Subject'],'Automatic reply')
        contains(triggerBody()?['Subject'],'#')
)
 
Let me know if this could potentially solve it.
 
Thanks 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,946)