web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Trying to use For a se...
Power Automate
Unanswered

Trying to use For a selected row without a Table as my table is dynamic

(0) ShareShare
ReportReport
Posted on by 2

Hi, I am trying to use the:

Send an email with options, but I will need to show some data from my excel workbook - ProjData that contains 4 different sheets. Working on the first Spreadsheet, - named "CR1 " 

To show the data, I will need to use the "For a selected row" function to extract the data needed. "For a selected row" has a "Table" option, that needs us, within excel, to manually convert tables to range and back to tables each time (because we the number of rows in "ProjData" is changed). - I have rummaged through the net for a solution to this by watching this video on

How to create Excel table dynamically - 

https://www.youtube.com/watch?v=Q4Q_OWEa-Jw&ab_channel=abmabm 

However, due to the nature of my 4 sheets, and a bunch of other issues, it is not working for me to automatically convert [table to range] and [non-empty cells to table]

 

I would require some advice on this. thank you for reading 

Categories:
I have the same question (0)

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard