cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MaWi
Level: Powered On

Re: SharePoint list item field updated

I want to hook onto this...

I created a flow like suggested with a switch statement on a column value. Works fine, thanks for sharing!

 

I have one issue.

Out of this line with the changed value i create a new list item in my calendar list. I try to set the start and end time of the new evnet to corresponding values of the list.

 

when I look into the results it looks like follows

This is what I have in my "trigger"

image.png

This is what i want to do as action

image.png

 

This is what happens

image.png

It always sets end date = null and thus the event will not show up in my calendar :-(

Any ideas?

Microsoft Employee

Re: SharePoint list item field updated

Looking at the screenshots you provided it looks like you're accidentally using the wrong variable to assign the end time.  You're using a variable called "End Time" in the flow when in the output screenshot you're showing a variable named "END Date" which looks like the correct format and the variable you want to assign the field End Time to.  👍

MaWi
Level: Powered On

Re: SharePoint list item field updated

Would be too easy. I Just created both. One is a calculated one. (Start + duration) the other is one i created for testing purpose. Manually added Date.
JenniferFGI
Level: Powered On

Re: SharePoint list item field updated

I was wondering if "a new trigger based soley on when a value changes" (as mentioned in the last post) was ever implemented.

Anonymous
Not applicable

Re: SharePoint list item field updated

I would wonder the same thing myself. Was this implemented?

rgbrasel
Level: Powered On

Re: SharePoint list item field updated

It's implemented in Nintex, which is far superior to Microsoft. Unfortunately, I no longer have Nintex Workflows. Maybe Micro$oft should just buy Nintex and use it.
Super User
Super User

Re: SharePoint list item field updated

Can you please elaborate on this. When I try the Modified it just pulls in a date...how do you use this to tell you which column you are looking to see if it was modified?

JimmyWork
Level 8

Re: SharePoint list item field updated

This is defintly something we need now.

GarciaMcG
Level: Powered On

Re: SharePoint list item field updated

Hi,
I’m trying this with an Options column and I’m getting an error message every time I try to trigger the flow.
I have a Status column with pre-established options and I want to trigger different actions depending on what Status the column is updated to.
The Switch control after the item change trigger seems ideal but I cant get it to work.

Help!
Highlighted
Super User
Super User

Re: SharePoint list item field updated

@GarciaMcG 

 

If you are clicking the field from the Dynamic content make sure you click ont he one that says "ColumnName Value" not just "ColumnName".

 

Choice fields are a pain in Flow sometimes!

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fourthImage

Australia Summit

Travel to Melbourne and network with thousands of peers!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 299 members 4,230 guests
Please welcome our newest community members: