Answered

Read data of a specific cell in a datatable

(0) Share

Report

Posted on by BasseART

Hi,

This is about the basics, but after reading the manual and posts, it still does not work. Most do read out data in loops, I want this time to read a specific cell in the table.

I have this Datatable and I want a website to navigate to the URL in row 0 and column 'URLs'.

I have tried:

%ExcelDataURLs[0][1]%

%ExcelDataURLs[0]['Topics']%

=ExcelDataURLs[0]['Topics']

=variables('ExcelDataURLs')[0]['Topics']

but none of them work. There are always 1 or 2 errors: deferred data type and/or unexpected characters.

Thx for your support!

Bart

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @BasseART ,

While creating the flow you have enabled the Power FX option.Power FX in PAD is still in Preview state ,so we dont recommend it to use in production or development.
Please trying creating the same flow by disabling the Power Fx option as shown in below image.It will solve your issue.

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

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
Verified answer

Riyaz_riz11 4,150 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi @BasseART ,

I hope you turned on Power FX, disable and try it will work as you expected, you are on right track. Power FX still in preview mode.

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

Regards,
Riyaz

Was this reply helpful? Yes No
AK88 453 on at

Like (1)

Report
Copy link

Link copied!

Hi @BasseART ,

As @VishnuReddy1997 mentioned, kindly try to recreate the same flow with disabling Power FX toggle. Also, when you read the value try %ExcelDataURLs[0]['URLs']% like this.

thanks,
if it resolved kindly mark it as Solution and give kudos!

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@BasseART

Please follow the below syntax:

Please note, as other mentioned you have created your flow with power fx enabled feature which is under preview, and it have many limitations as well.

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
BasseART 9 on at

Like (2)

Report
Copy link

Link copied!

Hello all,

Thanks a lot for your replies! This is my first impementation with Power Automate. It is working now, although had to rewrite some code again as I was mixing up %variable% and the Power FX way of doing it. I lost 4 hours with this 'new' feature 😞

Was this reply helpful? Yes No