Copy same setting from one user to another in the same group

Question

Hello All

I would like to build a flow in order to copy settings from one user to another within the same group, and formula can apply in all groups in one sheet..

Sample input and output provided below:

Input:

FirmUserProductBuySellHold1ABCAMYAppleYesYesNo2ABCBETApple

NoNoNo3ABCAMYBananaYesNoYes4ABCCATBananaNoNoNo5DEFENNAppleNoYesYes6DEFFRANKAppleNoNoNo7GHIGEOBananaNoNoYes8GHIHENRRYBananaNoNoNo

Output:

FirmUserProductBuySellHold1ABCAMYAppleYesYesNo2ABCBETApple

YesYesNo3ABCAMYBananaYesNoYes4ABCCATBananaYesNoYes5DEFENNAppleNoYesYes6DEFFRANKAppleNoYesYes7GHIGEOBananaNoNoYes8GHIHENRRYBananaNoNoYes

Thank you very much.

IraWatt · Answer

Hey @k3pineapple,

Im not sure why the third row needs to be removed. Does the workflow not just apply the same user settings to everyone in the same group?

k3pineapple · Answer

Hi @IraWatt , Thanks for your solution.

I found out if there is over 2 users has the same settings,  will also pop up in the out folder.

E.g.:

FirmNameProductBuySellHold 1ABCAMYAppleYesYesNo 2ABCBETApple

NoNoNo 3ABCCHARLIEApple

YesYesNo

the output will have 3 rows as well, but i only want two rows, one of them is the row which has been changed. Sample output:

FirmNameProductBuySellHold 1ABCAMYAppleYesYesNo 2ABCBETApple

YesYesNo

Is this "Sample" Function still work?

binu_acs · Answer

@k3pineapple one way of doing this

group_users_06_07.yxmd