Modified Date&Time changes for no apparent reason??

%3CLINGO-SUB%20id%3D%22lingo-sub-708866%22%20slang%3D%22en-US%22%3EModified%20Date%26amp%3BTime%20changes%20for%20no%20apparent%20reason%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708866%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20MS%20Flow%20that%20triggers%20when%20'SPO%20list%20item%20is%20created%20or%20modified'.%20Over%20night%20this%20flow%20triggered%20every%20hour%20-%20upon%20investigation%20I%20found%20that%20the%20modified%20date%26amp%3Btime%20of%20some%20list%20items%20appears%20to%20have%20changed%20each%20hour....%20but%20without%20any%20changes%20being%20made%20manually!%3F%3C%2FP%3E%3CP%3EEven%20more%20strangely%2C%20this%20only%20occurred%20on%20some%20items%20not%20others.%20The%20'Modified%20By'%20field%20shows%20myself%2C%20so%20I%20know%20that%20nobody%20else%20was%20editing%20these%20items%2C%20and%20I%20also%20know%20that%20I%20did%20not%20either.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20else%20experienced%20this%3F%3F%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20obviously%20a%20problem%20as%20I%20cannot%20have%20a%20Flow%20trigger%20each%20time%20erroneously.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-708866%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-715791%22%20slang%3D%22en-US%22%3ERe%3A%20Modified%20Date%26amp%3BTime%20changes%20for%20no%20apparent%20reason%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715791%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F313026%22%20target%3D%22_blank%22%3E%40DanielaH%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssuming%20that%20you%20created%20that%20Flow%2C%20your%20user%20account%20was%20used%20to%20create%20the%20connections%20to%20SharePoint%20Online%20and%20thus%20when%20the%20Flow%20executes%20it%20runs%20as%20YOUR%20user%20account.%26nbsp%3B%20This%20is%20why%20something%20would%20show%20as%20created%20or%20modified%20by%20you.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20the%20rest%2C%20can%20you%20please%20share%20more%20about%20your%20Flow%20and%20what%20exactly%20it%20does%3F%26nbsp%3B%20If%20you%20are%20just%20testing%20a%20Flow%20for%20awhile%20before%20you%20go%20live%20with%20it%2C%20you%20can%20switch%20the%20trigger%20to%20a%20Flow%20button%20manual%20trigger%20instead%20until%20you%20are%20ready%20to%20go.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-715820%22%20slang%3D%22en-US%22%3ERe%3A%20Modified%20Date%26amp%3BTime%20changes%20for%20no%20apparent%20reason%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715820%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F313026%22%20target%3D%22_blank%22%3E%40DanielaH%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%20to%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5855%22%20target%3D%22_blank%22%3E%40Doug%20Allen%3C%2FA%3E%26nbsp%3Bcomments%20and%20without%20knowing%20exactly%20how%20your%20flow%20is%20set%20up%2C%20it%20may%20also%20be%20worthwhile%20checking%20that%20your%20SPO%20trigger%20is%20not%20causing%20an%20infinite%20loop%20(e.g.%20when%20a%20change%20is%20made%20do%20something%2C%20when%20that%20something%20has%20happened%20the%20loop%20starts%20again%20as%20a%20change%20has%20been%20made%2C%20etc).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20look%20through%20the%20run%20history%20may%20confirm%20if%20this%20is%20happening%20(or%20not).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-715909%22%20slang%3D%22en-US%22%3ERe%3A%20Modified%20Date%26amp%3BTime%20changes%20for%20no%20apparent%20reason%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715909%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20both%20for%20your%20suggestions.%26nbsp%3BThe%20behavior%20seems%20to%20have%20stopped.%26nbsp%3B%3C%2FP%3E%3CP%3EPreviously%26nbsp%3BI%20had%20also%20turned%20off%20any%20Flows%20relating%20to%20this%20list%2C%20and%20the%20behavior%20stopped.%20So%20I%20assumed%20that%20the%20Flow%20may%20have%20caused%20a%20loop%2C%20but%20now%20after%20turning%20the%20Flow%20back%20on%20it%20still%20appears%20to%20be%20okay.%20Odd...%20but%20thank%20you%20all%20anyways!%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-715910%22%20slang%3D%22en-US%22%3ERe%3A%20Modified%20Date%26amp%3BTime%20changes%20for%20no%20apparent%20reason%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715910%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20both%20for%20your%20suggestions.%26nbsp%3BThe%20behavior%20seems%20to%20have%20stopped.%26nbsp%3B%3C%2FP%3E%3CP%3EPreviously%26nbsp%3BI%20had%20also%20turned%20off%20any%20Flows%20relating%20to%20this%20list%2C%20and%20the%20behavior%20stopped.%20So%20I%20assumed%20that%20the%20Flow%20may%20have%20caused%20a%20loop%2C%20but%20now%20after%20turning%20the%20Flow%20back%20on%20it%20still%20appears%20to%20be%20okay.%20Odd...%20but%20thank%20you%20all%20anyways!%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hello, 

I have a MS Flow that triggers when 'SPO list item is created or modified'. Over night this flow triggered every hour - upon investigation I found that the modified date&time of some list items appears to have changed each hour.... but without any changes being made manually!?

Even more strangely, this only occurred on some items not others. The 'Modified By' field shows myself, so I know that nobody else was editing these items, and I also know that I did not either. 

 

Has anyone else experienced this?? 

It is obviously a problem as I cannot have a Flow trigger each time erroneously.

 

4 Replies
Highlighted

@DanielaH,

 

Assuming that you created that Flow, your user account was used to create the connections to SharePoint Online and thus when the Flow executes it runs as YOUR user account.  This is why something would show as created or modified by you.  

 

For the rest, can you please share more about your Flow and what exactly it does?  If you are just testing a Flow for awhile before you go live with it, you can switch the trigger to a Flow button manual trigger instead until you are ready to go.  

Highlighted

Hi @DanielaH 

 

In addition to @Doug Allen comments and without knowing exactly how your flow is set up, it may also be worthwhile checking that your SPO trigger is not causing an infinite loop (e.g. when a change is made do something, when that something has happened the loop starts again as a change has been made, etc).

 

A look through the run history may confirm if this is happening (or not).

 

Cheers

Damien

Highlighted

Thank you both for your suggestions. The behavior seems to have stopped. 

Previously I had also turned off any Flows relating to this list, and the behavior stopped. So I assumed that the Flow may have caused a loop, but now after turning the Flow back on it still appears to be okay. Odd... but thank you all anyways! :)

Highlighted

Thank you both for your suggestions. The behavior seems to have stopped. 

Previously I had also turned off any Flows relating to this list, and the behavior stopped. So I assumed that the Flow may have caused a loop, but now after turning the Flow back on it still appears to be okay. Odd... but thank you all anyways! :)