Unanswered

Sharepoint list columns not displayed in the dynamic contents

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am trying to create a flow where when there is new list item added/modified in Sharepoint, it will automatically add a row in excel (online). When connecting the data, I am not able to pull the list of columns in the Sharepoint as they are not being displayed in the options.

Attachments:

1. Sharepoint list displaying columns

2. Flow not showing dynamic contents from the sharepoint list

Thanks

Categories:

Using connectors

All responses (3)

Answers (0)

Sort by

eric-cheng 5,171 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Can you scroll down and/or search for the beginning of the field name? In the screenshot below, aaaa appears near the end of my dynamic content values so it isn't necessarily alphabetical.

Alternatively, you can reference your SharePoint fields by replacing xxxx with the name of your SharePoint column and then pasting it as the Excel value.

@triggerOutputs()?['body/xxxx']
@triggerOutputs()?['body/Title']

OR

Passing the ID to a Get file properties action and accessing the properties that way

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eric-cheng
How to retrieve custom fields in jira, which are currently not being shown in dynamic content in power automate?
eric-cheng 5,171 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

You can use the JIRA APIs.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn