Unanswered

Read from Excel worksheet with Retrive as 'Values of Named cells'

(0) Share

Report

Posted on by Kishore_NOS

Read from Excel worksheet with Retrive as 'Values of Named cells' value as A1:A5,E1:E5,D1:D5 is extracting data only for column A1:A5. Intially this was working fine , but when I had updated the PAD to recent versions , it was pulling partail data only. Seems like its a Bug. Anyone can help on this

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Kishore_NOS

I am not sure if this is an issue in the current version, as I have not tried multiple selections with read excel. However, a workaround for your scenario is as follows:

First you extract your data like below:

To remove unwanted columns from a data table, you can use the 'delete column' function. For your scenario, delete columns B and C.

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
Kishore_NOS 2 on at

Like (0)

Report
Copy link

Link copied!

HI Deenuji - Thanks for providing the workaround, but I have already placed the workaround for that.
Could you please try the reading the desired columns range using Named cells and let me know if that is working without issues, as intially I used to get the results accurately, but when I updated to latest versions, the results are showing inaccurate

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

Like (0)

Report
Copy link

Link copied!

@Kishore_NOS

Yes already I tried this logic with version 2.45 but it returns only A column based values not all.

If you still believe this is the version issue, then you can confirm yourself by installing older version from the below link and confirm on your understanding.

[IMPORTANT] Cloud connector action issues in Power... - Power Platform Community (microsoft.com)

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