cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Christian_L
Level: Power Up

post a message in Teams when a Sharepoint file is modified or created

Hi everyone,

 

When a file is modified or created in a specific sharepoint file, i would like to post a message in a Team channel saying : "file name" has been "modified/created" by "name of the person".

 

In the dynamic contents of Sharepoint File, I have "file name" so this is ok.

Do you know how I can get the "modified" or "created" ?

And also, how can I get the name of the person that created/modified the file?

 

thanks a lot,

 

Christian 

1 ACCEPTED SOLUTION

Accepted Solutions
FilGouveia
Level: Powered On

Re: post a message in Teams when a Sharepoint file is modified or created

All available in Dynamic Content 🙂 

 

2019-04-09_14h15_37.png

View solution in original post

6 REPLIES 6
FilGouveia
Level: Powered On

Re: post a message in Teams when a Sharepoint file is modified or created

Standard fields in a document library include 'Created' (Date), 'Created by' (Person), 'Modified' (Date) and 'Modified by' (Person)

 

Should give you the info you need

Christian_L
Level: Power Up

Re: post a message in Teams when a Sharepoint file is modified or created

Thank you @FilGouveia Smiley Happy

 

Do you know if I can get this data from dynamic content?

Can it be retrieved through a function?

 

Thanks,

Christian 

FilGouveia
Level: Powered On

Re: post a message in Teams when a Sharepoint file is modified or created

All available in Dynamic Content 🙂 

 

2019-04-09_14h15_37.png

View solution in original post

Christian_L
Level: Power Up

Re: post a message in Teams when a Sharepoint file is modified or created

Thanks !

I will play with this.

The message from the bot is not very sexy inside the conversation, but it does the job.

 

I couldn't find it because I was using "When a file is created or modified in a folder" and not "properties only".

What is the difference?

 

Also, how can I do to have different messages when a file is created and when a file is modified?

With some logical functions ?

FilGouveia
Level: Powered On

Re: post a message in Teams when a Sharepoint file is modified or created

If you use When a file is created or modified in a folder your next step would need to be to get the File properties to pick up the metadata (Modified by, Modified date etc). "Properties only" does that anyway

 

Use conditions - I havent tested the below but may work. You might have to fiddle with the UTCNOW() 

 

2019-04-09_15h50_10.png

Christian_L
Level: Power Up

Re: post a message in Teams when a Sharepoint file is modified or created

Thanks a lot for your help @FilGouveia !


Have a great day!

Christian 

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,857)