How to add a condition to a flow so it triggers only when a specific column has a value

(0) Share

Report

Posted on by AngelinaSpring

I'd like to set up a flow that is triggered when a value is entered into a specific column on a list item.

For example...

When staff set up an appointment on site, they add the appointment to a list called 'Site Visits'.

When a new item is added, this already triggers an email to the admin team who then create a risk assessment. When this risk assessment is available, the url for the file is added to the original list item.

It then needs to be accepted by the staff member who created the appointment so I'd like an approval email to be sent to them when the admin team have added the url to the list.

Can anyone tell me how to set this up please?

Thanks

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AngelinaSpring,

Could you please show a bit more about your SharePoint list?

Do you want the flow to be triggered when the url for the file is added to the original list item?

Further, how does the url for the file is added to the original list item?

I suppose that you want the flow to be triggered when a specific column is filled with the url for the risk assessment file, is it true? I have made a test on my side and please take a try with the following workaround:

Add a "When an item is created" trigger, specify Site Address and List Name.

Add a "Send an email" action.

Add a "Do Until" action, click "Edit in advanced mode", type the following formula:

@not(empty(body('Get_item')?['File_x0020_URL0']))

Within "Do Until" action, add a "Get item" action, specify Site Address and List Name, Id field set to ID dynamic content of the trigger.

Under the "Do Until" action, add a "Start an approval" action.

Image reference:

The flow works successfully as below:

Best regards,

Kris

Was this reply helpful? Yes No
AngelinaSpring 25 on at

Like (0)

Report
Copy link

Link copied!

Hi - thanks for your quick response!

I've tested this, and it works in that I receive an email, however I receive that message regardless of whether or not there is a URL in the list item field so I think I may be missing a step.

Further information below - if you're able to help it would be very much appreciated.

The list item is created by a member of staff - at this point the 'Risk Assessment' column will be blank.
The Admin team receive an email highlighting a new item has been created.
The Risk Assessment file (word document) is create by an administrator and the Sharepoint url for the file is pasted into the 'Risk Assessment' column for the list item .
Column type is Hyperlink or Picture.

At this point I would like the original creator of the email to receive a request to accept the risk assessment, including a link to the url of the file.

Thank you!

Was this reply helpful? Yes No