Announcements
Hello, I have a problem while insert the variable where it has few rows. Example:
Any ideas why it happens and what could be a work around for this?
Thank you.
Hi @79
The way you have used the Set variable is not the way to create a datatable using Set Variable.
Refer below section in this link. Variable data types - Power Automate | Microsoft Learn
Additionally, you can create a datatable using the Set variable action and the programming array notation. This notation consists of multiple single-dimension arrays separated by commas and enclosed in curly brackets. The final expression must have the following form: %{['Product1', '10 USD'], ['Product2', '20 USD']}%.
It's not the problem, problem is that when I get data from Get details of element on webpage, I receive variable structure like that:
and when I try to add this variable to the table it only adds first line.. The same problem appeared in your proposed way:
Result as you can see only '1' is in the table and we missing 2 and 3:
It is clear from your first screenshot that the variable is a Text one.
Just use the Split Text with delimiter as Newline. This will automatically add them as separate rows in a Datatable.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Mohsin Ali 425
11manish 323 Super User 2026 Season 2
M Bilal Khan 274
