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

[Anonymous]

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 

[FilGouveia]

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

[Anonymous]

Thank you @FilGouveia 

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

Can it be retrieved through a function?

Thanks,

Christian 

[FilGouveia · Accepted solution]

All available in Dynamic Content 🙂 

[Anonymous]

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]

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() 

[Anonymous]

Thanks a lot for your help @FilGouveia !

---

Have a great day!

Christian