cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ArjunSudaS
Level: Power Up

Sharepoint Column names from list to flow

Hi all,

How can I get the names of the columns used in the sharepoint list? I would like to add this data to my flow email. Please help.

 

6 REPLIES 6
Harry_G
Level 8

Re: Sharepoint Column names from list to flow

Hi @ArjunSudaS ,

If you trigger your flow when item is created you can get your column like this, 

Capture.JPG

 

or if you want to get items than use your column values than you should follow these steps,

 

Capture.JPG

 

If you find it helpful, Please Accepts it as a Solution.

 

Thanks,

Harry_G

ArjunSudaS
Level: Power Up

Re: Sharepoint Column names from list to flow

Hi Harry,

 

I need to trigger the flow at some other scenario. The main thing I need is to capture the column names instead of the values inside the list. I may create a particular view for the list and  I want to get the name of the columns in the list as the body of my email. Is there any way to fetch the column name only without  content? See the figure below:

help.png

So suppose I would like to capture Created By and Created by Email and attach the same in my email message.

Thanks in advance for your help


Harry_G
Level 8

Re: Sharepoint Column names from list to flow

@ArjunSudaS ,

Sorry, I'm Afraid that there is no method exist to acheieve this. i Think you have to use some logic on your list for example make a duplicate list and add a row with same data present in column header and then get this row to acheieve your functionality.

 

Thanks,

Harry_G  

Super User
Super User

Re: Sharepoint Column names from list to flow

Hi @ArjunSudaS .

Can you post the context of this request and exactly what you want to use the data from the column headers for?

So I am reading between the lines a little here, but maybe you want to output at table? If so, use create HTML table for that as below.capture-271.pngOtherwise, please can you give us more information and post some pictures of your Flow and your desired goal and we will assist?

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


ArjunSudaS
Level: Power Up

Re: Sharepoint Column names from list to flow

this seems to be a nice option, similar to what i require.

Highlighted
ArjunSudaS
Level: Power Up

Re: Sharepoint Column names from list to flow

But frankly speaking I may not be able to use this as a solution since I may be reading data from different lists dynamically due to a different requirement

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,701)