Adding column to Sharepoint using Power Automate

(0) Share

Report

Posted on by nickas

228

Hello,

I would like to ask how to add a column in sharepoint using Power Automate. Now I have current result - I am able to attach file to Sharepoint but how to make to add new column with sender email address field? What step to use?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

@nickas there's no action in Power Automate to add a column to a SharePoint list. Why not just add the column yourself to SharePoint then use, for example, the Update Item action.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
nickas 228 on at

Like (0)

Report

@RobElliott I have attached file in Sharepoint. Now I need to see email address of sender in separate column in Sharepoint. How accomlplish this? Because email address appears in same column where attached file exists. I need to separate attached file name and sender email address.

Was this reply helpful? Yes No
ThomasDK 265 on at

Like (0)

Report

Hi @nickas

Use the SP connector called "Send an HTTP request to Sharepoint".

Here I create a column for email "CC" UPNs:

There are different "FieldTypeKind" depending on what column type you need. Check these out:
Microsoft.SharePoint.Client namespace () | Microsoft Docs
FieldChoice members (Microsoft.SharePoint.Client) | Microsoft Docs
FieldType Enum (Microsoft.SharePoint.Client) | Microsoft Docs <-- Especially this one
FieldType enumeration (Microsoft.SharePoint.Client) | Microsoft Docs

E.g. "Date" is made like this

{
'__metadata': {'type':'SP.FieldDateTime'},
'FieldTypeKind': 4,
'Title': 'Date Recieved',
'StaticName': 'Date Recieved'
}

..and Multichoise is made like this:

{
'__metadata': {'type':'SP.FieldMultiChoice'},
'FieldTypeKind': 15,
'Title': 'Opgaveresultat',
'StaticName': 'Opgaveresultat',
'Choices': { 'results': ['Godkendt','Afvist']}
}

I hope it helps?

BR,
Thomas

1 people found this reply helpful.

Was this reply helpful? Yes No
nickas 228 on at

Like (0)

Report

Hello @ThomasDK I already have a column with name "Email address" how I can make that running my flow sender email will be inserted in that column? What I have to add? Here is my flow:

Was this reply helpful? Yes No
ThomasDK 265 on at

Like (0)

Report

Hi @nickas

OK, so you add a column as described above (if it is not already there) and then you save all the attachments and use the "Update Item" Sharepoint connector to set the "sender Email" with your newly saved "sender email" (From, I think it is called) value.

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (1)

Report

@nickas

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No