Create Sharepoint List Item from Channel Post

(1) Share

Report

Posted on by AS-11032008-0

I have a form (from jotform) that sends a channel post to a Team with general information on the submission.

Request #:

Job:

Requested Date/Time:

I would like to have the submitted information added to a list in the same channel. Is there any way to automate this so it pulls the information from the post (each separate line above) into its own column for the list item?

Categories:

Using flows

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,183 Most Valuable Professional on at

Like (0)

Report
Hi @AS-11032008-0,

Are you using a Power Automate cloud flow for the integration between the JotForm and Teams?

https://learn.microsoft.com/en-us/connectors/jotform/

Or are you using the integration options within JotForm itself?

https://www.jotform.com/help/how-to-integrate-microsoft-teams-with-jotform

In case of the latter you could use a When a new channel message is added trigger action for this. You can use some split functions in a couple of expressions to retrieve the content from the body/body/content property and reuse it in a Create Item action.

Below is an example

Request column

split(split(triggerOutputs()?['body/body/content'], 'Request #:')[1], '')[0]

Job column

split(split(triggerOutputs()?['body/body/content'], 'Job:')[1], '')[0]

Requested On

split(split(triggerOutputs()?['body/body/content'], 'Requested Date/Time: ')[1], '')[0]

Test result

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No