Unanswered

Updating variable values to a data table

(0) Share

Report

Posted on by Sh99

Hello,

can someone help with inserting a row into datatable with values to be passed as variables? I am using the command insert row into data table , but need the correct syntax to pass variables as values.

Thanks.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

WillSG 352 Moderator on at

Like (0)

Report
Hi @Sh99 I hope you are doing well.

I will assume that you are using the For Each Action which will give us the variable %CurrentItem%.
Now, PAD listing is based 0, that means that if you have 5 columns with data, the numbers assigned to each column would be 0,1,2,3,4.

So, when you have data into the %CurrentItem% and let’s assume that your data goes like this, Name, Last Name, Address, Phone and Email, the values will be assigned to the variable in this order:
Name: %CurrentItem[0]%
Last Name: %CurrentItem[1]%
Address: %CurrentItem[2]%
Phone: %CurrentItem[3]%
Email: %CurrentItem[4]%

Again, I’m assuming here because there is not enough information, but if you ever work with the For Each action, the steps above will help you accomplish the automation.

Please let me know if it works, happy automation!,

If I have addressed your inquiry successfully, kindly consider marking my response as the preferred solution. If you found my assistance helpful, a 'Thumbs Up' would be greatly appreciated.

Additionally, I offer specialized consultancy and development services leveraging PAD. If you're interested in exploring these services further, feel free to DM me, and we can initiate a discussion.

Kind regards,

Will SG
Managing Director & Automation Lead
RAMS CR (Recruitment & Automation)
LinkedIn Profile

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

Like (0)

Report

@Sh99 @Hope you are doing well!!

please share some screenshot to understand your flow logic and errors?

Thanks
Deenu

Was this reply helpful? Yes No
Sh99 61 on at

Like (0)

Report

Hello please refer to the attached screenshot, in the last command, insert row into datatable , What is the syntax to add varaibles as values?

Screenshot 2024-0...

Screenshot 2024-0...

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

Like (0)

Report

@Sh99. Please follow the below method to add your variable values into your data table.
Code:
SET EmpName TO $'''Deenu'''
SET Age TO 18
Variables.CreateNewDatatable InputTable: { ^['EmpName', 'EmpID'], [$'''''', $''''''] } DataTable=> DataTable
SET DataTable TO DataTable + [EmpName, Age]

Thanks,
Deenu

Was this reply helpful? Yes No
Sh99 61 on at

Like (0)

Report

okay , could you please show me the next command as well what you have put for values in insert row command?

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

Like (0)

Report

@Sh99 - Adding variables directly into the insert row action is not accepted. Therefore, I utilized the set variable action in the command above. However, if you still wish to add your data through the insert row action, please review the details below.

According to Microsoft documentation, the insert row action in DataTable only accepts two data types: List or DataRow. Please refer to the following link for more information:

Variables actions reference - Power Automate | Microsoft Learn

I have implemented the same in the example use case below, and it works when passing data row or List. Please review it:

Code:
Variables.CreateNewDatatable InputTable: { ^['EmpName', 'EmpID'], [$'''''', $''''''] } DataTable=> DataTable
Variables.CreateNewList List=> ListEmpName
Variables.CreateNewList List=> ListEmpAge
Variables.AddItemToList Item: $'''Deenu''' List: ListEmpName
Variables.AddItemToList Item: $'''Loganathan''' List: ListEmpName
Variables.AddRowToDataTable.AppendRowToDataTable DataTable: DataTable RowToAdd: ListEmpName
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Deenu\\Accounts_Details.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: False RangeValue=> ExcelData
SET EmpName TO $'''Deenu'''
SET Age TO 18
SET DataTable TO DataTable + [EmpName, Age]
LOOP FOREACH CurrentItem IN ExcelData
Variables.AddRowToDataTable.AppendRowToDataTable DataTable: DataTable RowToAdd: CurrentItem
END

Thanks,
Deenu
-----------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up. Thank you.

Was this reply helpful? Yes No