Home

Microsoft FLOW - Issues handing columns with multiple values.

%3CLINGO-SUB%20id%3D%22lingo-sub-194664%22%20slang%3D%22en-US%22%3EMicrosoft%20FLOW%20-%20Issues%20handing%20columns%20with%20multiple%20values.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-194664%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20looks%26nbsp%3Blike%20the%20Microsoft%20FLOW%20might%20be%20having%20an%20issue%20wherein%20in%20SharePoint%20when%20it%20tries%20to%20update%20a%20destination%20list%20(say%20%22List%20D%22)%20item%20from%20a%26nbsp%3Bsource%20list%26nbsp%3B%3CSPAN%3E(say%20%22%3C%2FSPAN%3E%3CSPAN%3EList%20S%22)%20item%26nbsp%3B%3C%2FSPAN%3Ewhich%20has%20a%20column%20which%20contains%20more%20than%20one%20value%20(e.g.%26nbsp%3Bthe%20list%20item%20has%20an%20%22assigned%20to%22%20column%20which%20can%20have%20more%20than%20one%20value%20for%20a%20single%20item).%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20my%20FLOW%20diagram%20below.%26nbsp%3BThis%20workflow%20basically%20run%20when%20an%20item%20is%20%22added%20or%20modified%22%26nbsp%3Bon%26nbsp%3BList%20S%2C%26nbsp%3Band%20it%20adds%2Fupdates%20the%20entry%20on%20List%20D.%20(The%20'add'%20vs%20'update'%20decision%20is%26nbsp%3Bmade%20by%20comparing%20the%20%22created%22%20and%20%22modified%22%20timestamps).%20The%20%22addition%22%20part%20works%20perfectly%20i.e.%20if%20I%20add%20an%20action%20item%20in%20list%20S%20and%20assign%20that%20to%20two%20users%20(user%20A%20and%20B)%2C%20then%20the%20%22Add%22%20operation%20adds%20two%20items%20in%20List%20D%20(one%20for%20user%20A%20and%20other%20for%20user%20B).%20When%20I%20%22update%22%20the%20source%20list%20then%20in%20the%20FLOW%20I%26nbsp%3B%20identify%20the%20destination%20item%20by%20comparing%20the%20source%20list%20item's%20%22ID%22%20stored%20in%20destination%20item%20at%20the%20time%20of%20%22Add%22).%20During%20this%20update%20operations%20although%20the%20FLOW%20does%20update%20the%26nbsp%3Btwo%26nbsp%3Bitems%20on%20the%20list%20D%2C%20but%20for%20both%20the%20items%20it%20updates%20the%20user%20as%20%22B%22%26nbsp%3Beven%20though%20the%20source%20has%20A%20and%20B%20both.%20The%20expectation%20was%20that%20it%20will%20take%20the%20source%20lists%20both%20the%20IDs%20and%20update%20the%20destination%20list%20one%20by%20one%20for%20each%20user%20ID.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20any%20insights.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20725px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34327i3CBC8E100B890792%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22FLOW-1.png%22%20title%3D%22FLOW-1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%2C%26nbsp%3Bsince%20FLOW%20does%20not%20handle%20%22users%20and%20groups%22%20columns%2C%20I%20basically%20pass%20the%20%22email%20address%22%20of%20the%20user%20from%20FLOW%20into%20the%20destination%20list's%20email%20column%20and%20then%20I%20run%20a%20separate%20native%20workflow%20to%20take%20the%20email%20value%20and%20populate%20the%20%22user%20and%20group%22%20column%20in%20the%20destination%20list.%20The%20email%20and%20user%20group%20stuff%20works%20perfectly%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-194664%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-194695%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20FLOW%20-%20Issues%20handing%20columns%20with%20multiple%20values.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-194695%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F48378%22%20target%3D%22_blank%22%3E%40Vivek%20Jain%3C%2FA%3E%26nbsp%3BSorry%20to%20say%20this%20Sir%20but%20Flow%20Product%20forums%2Fsupport%20are%20not%20handled%20through%20the%20Tech%20Community.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20repost%20this%20Here%20after%20searching%20for%20similar%20threads%20for%20better%20results%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FMicrosoft-Flow-Community%2Fct-p%2FFlowCommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FMicrosoft-Flow-Community%2Fct-p%2FFlowCommunity%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Vivek Jain
Contributor

It looks like the Microsoft FLOW might be having an issue wherein in SharePoint when it tries to update a destination list (say "List D") item from a source list (say "List S") item which has a column which contains more than one value (e.g. the list item has an "assigned to" column which can have more than one value for a single item).

  

Please see my FLOW diagram below. This workflow basically run when an item is "added or modified" on List S, and it adds/updates the entry on List D. (The 'add' vs 'update' decision is made by comparing the "created" and "modified" timestamps). The "addition" part works perfectly i.e. if I add an action item in list S and assign that to two users (user A and B), then the "Add" operation adds two items in List D (one for user A and other for user B). When I "update" the source list then in the FLOW I  identify the destination item by comparing the source list item's "ID" stored in destination item at the time of "Add"). During this update operations although the FLOW does update the two items on the list D, but for both the items it updates the user as "B" even though the source has A and B both. The expectation was that it will take the source lists both the IDs and update the destination list one by one for each user ID.

 

Appreciate any insights.

 

FLOW-1.png

 

Please note, since FLOW does not handle "users and groups" columns, I basically pass the "email address" of the user from FLOW into the destination list's email column and then I run a separate native workflow to take the email value and populate the "user and group" column in the destination list. The email and user group stuff works perfectly fine.

 

 

1 Reply

@Vivek Jain Sorry to say this Sir but Flow Product forums/support are not handled through the Tech Community. 

 

Please repost this Here after searching for similar threads for better results: https://powerusers.microsoft.com/t5/Microsoft-Flow-Community/ct-p/FlowCommunity

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies