To create DataTable in Power Automate Desktop

[Anjali_Rani]

Hi everyone,

Can any one tell me ,

1) how e can add Datatable activity in Power automate desktop, ?

2) How we can store in dadatble variable, so that finally we write that variable into ExcelFile?

3) How to convert variable to Datatable?

Please help me!!

I have to store value in Excel file,Any suggestions/Hint will work.

Please give suggestions.

Thanks in Advance.

[ryule · Accepted solution]

Information on creating your own DataTable is located under "Datatable" under Advanced Data Types in this link:

https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#advanced-data-type...

I, however, have not discovered a way to insert a variable into a custom datatable....so if anyone knows how to do that, I'm all ears. I've had to use Excel as a workaround, like you had mentioned.

[Anjali_Rani]

Thanks, This helped a lot.

Thank you so much. 🙂

[amanwadhwa990]

Use %vData + [rowd, rowdd]% where rowd , rowdd are variables and vData is datatable.