Ticketing Board

(0) Share

Report

Posted on by bB-27090143-0

Hi all

I have a ticketing board with 3 particular columns I want to select in my flow

Who will this impact (department)

Status (New, Duplicate, Inprogress and Completed)

Approval Status (Pending, Approved and Declined)

Scoped (yes or no choice)

When an item is created a response is sent to the creator

Currently status are

Status New

Approval Status Pending

Scoped no

Email is sent to Ticketing team

Change Scoped status to yes triggers this flow (attached0

How do I add condition to only look for Scoping column change?

Once Scoped to Yes - this will send email to Department lead for approval status to change to Approved or Decline

Once approved then more flow

Can someone assist make this work please?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Suggested answer

MichaelFP 1,999 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi!

click on the three dots of the trigger and after click an settings, you will have trigger conditions and you can apply your formula to validate.

If my answer helped you, please give me a thumbs up (👍). If solve your question please mark as answer ✔️. This is help the community.

Was this reply helpful? Yes No
Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@MichaelFP, the trigger you suggested reduces the number of flow runs (to only items which are modified), which is a good improvement for this setup 👍.

However, it doesn't check if the value in the Scope column has changed in the last update (changes between versions).

As far as I understand bB-27090143-0 wants to check this as well. If that is the case, you would also need the Get changes for an item or a file (properties only) action: https://learn.microsoft.com/en-us/connectors/sharepointonline/#get-changes-for-an-item-or-a-file-(properties-only)

Was this reply helpful? Yes No
Verified answer

bB-27090143-0 51 on at

Like (0)

Report
Copy link

Link copied!

I have the following

See attached

But I cant even test it now it seems to be glitching

Was this reply helpful? Yes No
MichaelFP 1,999 Moderator on at

Like (2)

Report
Copy link

Link copied!

@Expiscornovus, i just show that he can use trigger conditions to validate that. i don't said that he have to use the specific formular.

Was this reply helpful? Yes No
Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@MichaelFP, yes, of course. Thanks for sharing that. Really appreciate your help 🙂

Was this reply helpful? Yes No
bB-27090143-0 51 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much for your responses...

I am so stuck

I have modified columns for approval status to have scoped included

Approval status now pending, Scoped, Approved, Declined

But still erroring "Action 'Get_changes_for_an_item_or_a_file_(properties_only)' failed: Invalid format for version input value clientRequestId: 7f8e233d-a6b2-415a-8450-b51a18625b5c serviceRequestId: 955864a1-30b8-4000-1fdc-cae32a8a68c6

Was this reply helpful? Yes No
Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

The since field expects a version value. Normally you can use the Trigger Window Start Token for this. Can you try that one instead?

Until can use the Trigger Window End Token.

After that the action should return if the Scope field had changed (true value).

Was this reply helpful? Yes No
bB-27090143-0 51 on at

Like (1)

Report
Copy link

Link copied!

Got it working all

Thanks so much!@

Was this reply helpful? Yes No