You’re offline. This is a read only version of the page.
12
While creating this flow, my requirement is to to access the column names along with the values for the choice/look up fields of my share point list in the dynamic content.
I understand triggerOutputs()?['body/Value'] dynamic content is based on my 'When an item is created or modified' trigger. But how to get the corresponding column filed names into this flow?
for example in the email I want to include
if 'Choice question' is not null then the corresponding 'triggerOutputs()?['body/Value']'
if null then it should be blank or nulls ' '
-Thanks
Here is what I figured out and it worked!
If you would like to access the column headers of the share point list, for every header we have to initialize the variable as string and compose the variable with the logic accordingly. In my case, I have almost 15 headers which I have to initialize and put if logic in the compose steps. The output of these 'compose variables' can be used in the HTTP request to SharePoint flow anywhere. These steps are needed because we cannot use any of the regular expressions / logic in html code/JSON body of the content.
attached screenshots for reference.
-Thanks
Thanks for the reply. It won't work. I tried this before asking here in this community forum.
triggerOutputs()?['body/ChoiceColumnName'] means
{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value": " "}
not the column name.
any other ideas to retrieve these column names in dynamic content ?
Thanks
HI @idsree3 ,
You can use this code where replace columnname with actual column name in list -
Share
Report
All responses (
Answers (
if(
equals(triggerOutputs()?['body/ChoiceColumnName'], null),
'',
triggerOutputs()?['body/ChoiceColumnName/Value']
)
Please give kudos and mark as solution if it helps.
Thanks,
Sandeep Mishra
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
