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

[k3pineapple]

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:

	Firm	User	Product	Buy	Sell	Hold
1	ABC	AMY	Apple	Yes	Yes	No
2	ABC	BET	Apple	No	No	No
3	ABC	AMY	Banana	Yes	No	Yes
4	ABC	CAT	Banana	No	No	No
5	DEF	ENN	Apple	No	Yes	Yes
6	DEF	FRANK	Apple	No	No	No
7	GHI	GEO	Banana	No	No	Yes
8	GHI	HENRRY	Banana	No	No	No

Output:

	Firm	User	Product	Buy	Sell	Hold
1	ABC	AMY	Apple	Yes	Yes	No
2	ABC	BET	Apple	Yes	Yes	No
3	ABC	AMY	Banana	Yes	No	Yes
4	ABC	CAT	Banana	Yes	No	Yes
5	DEF	ENN	Apple	No	Yes	Yes
6	DEF	FRANK	Apple	No	Yes	Yes
7	GHI	GEO	Banana	No	No	Yes
8	GHI	HENRRY	Banana	No	No	Yes

Thank you very much.

[IraWatt]

Hey @k3pineapple,

Here is one way to do this:

The sample tool takes the first element from each group. Then the join tool adds that elements settings to all others in that group.

Any questions or issues please ask :)
HTH!
Ira

[grazitti_sapna]

Hi @k3pineapple, another way of solving this problem.

Thanks!

[binuacs]

@k3pineapple one way of doing this

[k3pineapple]

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.:

	Firm	Name	Product	Buy	Sell	Hold
1	ABC	AMY	Apple	Yes	Yes	No
2	ABC	BET	Apple	No	No	No
3	ABC	CHARLIE	Apple	Yes	Yes	No

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:

	Firm	Name	Product	Buy	Sell	Hold
1	ABC	AMY	Apple	Yes	Yes	No
2	ABC	BET	Apple	Yes	Yes	No

Is this "Sample" Function still work?

[IraWatt]

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?