How to create a new file from a SharePoint list with condition

[SoufTC]

Hello, It's my first flow with Power Automate.

I have a Sharepoint list with two columns : 

X	ID
A,#B	1
A,#B,#C,#D	2

I would like to split the column and create a list sharepoint or Excel file as follows:

X	ID
A	1
B	1
A	2
B	2
C	2
D	2

I don't know if this is possible? Thank's in advance

[v-bofeng-msft]

Hi @SoufTC :

Could you tell me:

• What is 'X''s datatype?Is it a 'single line of test' column.

If so,the point is to use the 'Split' function.I've made a test for your reference:

1\My DataSource

2\My Flow

Reference Expressions:

1\

split(items('Apply_to_each')?['Title'],',#')

2\

items('Apply_to_each_2')

The Result:

Best Regards,

Bof

[SoufTC]

Hi @v-bofeng-msft !

First thank you very much for your answer it's very nice of you.

X is a multiple choice answer,  I think that's why I have this error 

[v-bofeng-msft · Accepted solution]

Hi:

OK.I get it.Please try this flow:

1\My data source

2\My flow

Best Regards,

Bof

[SoufTC]

@v-bofeng-msftThank's a lot it works 🙂