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
Solved! Go to Solution.
Hi:
OK.I get it.Please try this flow:
1\My data source
2\My flow
Best Regards,
Bof
Hi @SoufTC :
Could you tell me:
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\
2\
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
Hi:
OK.I get it.Please try this flow:
1\My data source
2\My flow
Best Regards,
Bof
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
14 | |
4 | |
4 | |
4 | |
4 |
User | Count |
---|---|
10 | |
6 | |
6 | |
5 | |
5 |