Set the date to another date column you’ve retrieved in the Flow less 30 days: addDays(triggerBody()?,-30)Īll times are expressed in UTC in Microsoft Flow.
Set the date to 1 week ahead: addDays(utcNow(),7).You can do any kind of date math in the expression as well. “Set the date to today”… Build an expression to hold today’s date and then set the column to it (image). Let’s differentiate a Date Only column from a Date & Time column which is this option selected during column definition. Note: If you’ve defined the choice column to allow Fill-in choices (below), you can enter a value not included in the list of choices, otherwise you must choose one of the pre-set values. (Depending on the logic you have in the Flow) You can either select one of the choices directly or select Enter custom value to point to a variable in the Flow containing the value you want. You get intellisense on the drop down for this column with the values entered in the column definition. Here are the 5 column names and their column types for my examples:Īll examples are using the Update item action to update the value in SharePoint. This column requires you to update 2 properties: the URL and the Description.Ĭheck out my other Power User post, Microsoft Flow: Condition syntax for SharePoint columns, where I demonstrate condition-checking for these same 5 column types. Are you a Power User working with SharePoint in Office 365? Do you plan on using a SharePoint list or library with Microsoft Flow? If so, read on! In this post, I’ll show how to update SharePoint values when building a Microsoft Flow for five frequently used SharePoint column data types: Choice, Date and Time, Lookup, Managed Metadata, and Yes/No.
0 kommentar(er)
