Answered

sending an email via Send an HTTP request to SharePoint with When an item is created or modified trigger

(1) Share

Report

Posted on by idsree3

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

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

sandeepstw 312 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
HI @idsree3 ,

You can use this code where replace columnname with actual column name in list -

if( equals(triggerOutputs()?['body/ChoiceColumnName'], null), '', triggerOutputs()?['body/ChoiceColumnName/Value'] )

Please give kudos and mark as solution if it helps.

Thanks,
Sandeep Mishra

Was this reply helpful? Yes No
idsree3 12 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

idsree3 12 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No