cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ArjunSudaS
New Member

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.

 

8 REPLIES 8
Harry_G
Kudo Kingpin
Kudo Kingpin

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

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


@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  

AlanPs1
Resident Rockstar
Resident Rockstar

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!


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

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

I am facing the same issue, I want to retrieve column names with a particular value For ex. I want the columns with value 2. How can i retrieve this from sharepoint list.

 

Use case:

get MS Form data -> input to list -> get column names where user has chosen 2 as option -> send email with those column names.

 

Need the solution on urgent basis. Really appreciate any help. Thanks!

3tsolutions
Frequent Visitor

Hi,

 

I have created a custom solution that perhaps can be useful to you..

 

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-get-columns-name-from-sharepoint-list/td... 

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,431)