How to convert text value into datatable

(0) Share

Report

Posted on by aggneha9821

Hi, plz refer to attached screenshot.

Need to convert this text value into datatable

Categories:

Power Automate Desktop

IMG_20240506_1742...

I have the same question (0)

All responses (8)

Answers (3)

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report
Use Split text and insert that lint into datatable:

Code:
Variables.CreateNewDatatable InputTable: { ^['Column1', 'Column2'], [$'''''', $''''''] } DataTable=> DataTable3 SET NewVar3 TO $'''LYNN, ALANNA''' Text.SplitText.SplitWithDelimiter Text: NewVar3 CustomDelimiter: $''',''' IsRegEx: False Result=> TextList Variables.AddRowToDataTable.AppendRowToDataTable DataTable: DataTable3 RowToAdd: [TextList[0], TextList[1]]

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@aggneha9821

Try the below code:

Output:
Code:
SET Datatable TO {['LYNN', 'ALANNA'] }

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report
Hi @aggneha9821 ,

As per my understanding i have created a flow.
Please find the solution.

Code:

SET Memeber TO $'''LYNN,ALANNA''' Text.SplitText.SplitWithDelimiter Text: Memeber CustomDelimiter: $''',''' IsRegEx: False Result=> Member_As_TextList Variables.CreateNewDatatable InputTable: { ^['Column1'], [$''''''], [$''''''], [$''''''], [$''''''], [$''''''], [$''''''], [$''''''], [$''''''], [$''''''] } DataTable=> Memeber_As_DataTable SET RowValue TO 0 LOOP FOREACH CurrentItem IN Member_As_TextList Variables.ModifyDataTableItem DataTable: Memeber_As_DataTable ColumnNameOrIndex: 0 RowIndex: RowValue Value: CurrentItem Variables.IncreaseVariable Value: RowValue IncrementValue: 1 END

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
aggneha9821 52 on at

Like (0)

Report

@Deenuji @eetuRobo I need this text value in a one cell only ....I don't want to split it

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

Then just use Insert row into data table. It depends on your datatable how the insert works. How many columns you have? Can the other columns just be empty or do you want some value into them?

Was this reply helpful? Yes No
Verified answer

VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report

Hi @aggneha9821 ,

Please find the attached solution.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@aggneha9821

Simple one:
This method won't come up with empty row at first row

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report
@aggneha9821

The below two methods come up with first row as empty row so you have to delete the index 0 using delete row from datatable action.

Method 2:
Code:

SET Member TO $'''LYNN, ALANNA''' SET Datatable TO {[''] } SET DataTable TO DataTable + [Member] Variables.DeleteRowFromDataTable DataTable: DataTable RowIndex: 0

Method3:
Code:

SET Member TO $'''LYNN, ALANNA''' Variables.CreateNewDatatable InputTable: { ^['Column1'], [$''''''] } DataTable=> DataTable SET DataTable TO DataTable + [Member] Variables.DeleteRowFromDataTable DataTable: DataTable RowIndex: 0

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No