Using Expressions in a Select Action

%3CLINGO-SUB%20id%3D%22lingo-sub-217924%22%20slang%3D%22en-US%22%3EUsing%20Expressions%20in%20a%20Select%20Action%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-217924%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%26nbsp%3Bgetting%20an%20array%20of%26nbsp%3BSharePoint%20items%2C%20but%20I'd%20like%20to%20convert%20the%20time%20to%20UTC.%20I%20am%20attempting%20to%20do%20this%20from%20an%20expression%20but%20I%20don't%20get%20the%20option%20to%20add%20the%20field.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20first%20complex-ish%20flow%20I've%20tried.%20Any%20guidance%20would%20be%20much%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-217924%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-229475%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Expressions%20in%20a%20Select%20Action%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-229475%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20you%20are%20asking%20if%20you%20can%20convert%20the%20time%20from%20the%20SharePoint%20list%20to%20UTC%20Time%20and%20write%20it%20back%20to%20the%20SharePoint%20List%3F%26nbsp%3B%20If%20this%20is%20the%20case%20you%20just%20add%20a%20update%20item%20action%2C%20and%20put%20the%20expression%20%22convertToUTC%22%20in%20the%20field%20you%20will%20want%20to%20write%20to.%26nbsp%3B%20This%20will%20create%20a%20for%20each%20item%20loop%20that%20will%20update%20all%20of%20the%20items%20in%20your%20SharePoint%20List.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20putting%20the%20SharePoint%20List%20into%20a%20Variable%20Array%2C%20you%20can%20add%20the%20action%20%22Data%20Operations%20Select%22%20and%20select%20what%20values%20you%20want%20in%20your%20array%2C%20including%20converting%20that%20date%20to%20UTC%2C%20and%20then%20resetting%20the%20variable%20base%20on%20the%20output%20of%20your%26nbsp%3B%3CSPAN%3E%22Data%20Operations%20Select%22%3C%2FSPAN%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Hello, 

 

I'm getting an array of SharePoint items, but I'd like to convert the time to UTC. I am attempting to do this from an expression but I don't get the option to add the field. 

 

This is the first complex-ish flow I've tried. Any guidance would be much appreciated. 

 

Thanks.

1 Reply
Highlighted

I think you are asking if you can convert the time from the SharePoint list to UTC Time and write it back to the SharePoint List?  If this is the case you just add a update item action, and put the expression "convertToUTC" in the field you will want to write to.  This will create a for each item loop that will update all of the items in your SharePoint List.

 

If you are putting the SharePoint List into a Variable Array, you can add the action "Data Operations Select" and select what values you want in your array, including converting that date to UTC, and then resetting the variable base on the output of your "Data Operations Select".

 

I hope this helps.