Flag/conditional formatting for updates to SharePoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-1461043%22%20slang%3D%22en-US%22%3EFlag%2Fconditional%20formatting%20for%20updates%20to%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1461043%22%20slang%3D%22en-US%22%3EI%20am%20creating%20a%20flow%20that%20updates%20a%20SharePoint%20list%20based%20on%20an%20excel%20file%20update%20i.e.%20values%20either%20update%20or%20new%20ones%20are%20imported%20based%20on%20the%20excel%20file%20update.%20I%20would%20like%20to%20flag%20the%20values%20that%20update%20after%20the%20import.%20Is%20there%20a%20way%20to%20do%20this%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1461043%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1461269%22%20slang%3D%22en-US%22%3ERe%3A%20Flag%2Fconditional%20formatting%20for%20updates%20to%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1461269%22%20slang%3D%22en-US%22%3EYou%20could%20create%20a%20view%20that%20shows%20everything%20from%20the%20time%20the%20excel%20import%20runs%20so%20you%20only%20see%20updates.%20But%20in%20order%20to%20see%20with%20existing%20items%20you%20would%20have%20to%20loop%20through%20all%20items%20and%20reset%20them%20and%20then%20flag%20the%20ones%20you%20update%20as%20part%20of%20the%20flow%20using%20an%20%E2%80%9CisUpdated%3F%E2%80%9D%20Column%20or%20something.%3C%2FLINGO-BODY%3E
Occasional Visitor
I am creating a flow that updates a SharePoint list based on an excel file update i.e. values either update or new ones are imported based on the excel file update. I would like to flag the values that update after the import. Is there a way to do this?
1 Reply
You could create a view that shows everything from the time the excel import runs so you only see updates. But in order to see with existing items you would have to loop through all items and reset them and then flag the ones you update as part of the flow using an “isUpdated?” Column or something.