Unanswered

Creating an "If a file is opened" trigger

(0) Share

Report

Posted on by myNameIsA-aron

I'm looking for a way to create a read receipt for a client. I know there isnt a "if a file is opened" trigger, but is there any other ideas on once a file is opened, I could write the users name to another list as an acknowledgment?

Initially I created a manual trigger that "for a selected file" if wrote the username and file name to another list, but my issue is that it only worked on non-mobile devices and the primary need was for mobile functionality. My second thought was the auto trigger when a file was opened. Any thoughts?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Brad_Groux 4,556 on at

Like (0)

Report

Re: Creating an "If a file is opened" trigger

This isn't something possible with Flow, as Flow is not a security and governance tool. This type of security auditing should be done at the system or platform level.
For Office 365, you can access these tools at https://protection.office.com or by choosing Security & Compliance Center from the Office 365 portal:
You can also enable directly from within SharePoint:
To offer similar reporting on Windows-based systems, you'd have to utilize a security product of some sort.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

v-yamao-msft on at

Like (1)

Report
Re: Creating an "If a file is opened" trigger

Hi @myNameIsA-aron ,

Flow doesn’t have a trigger for “When a file is opened”. You may try if the following two ways will be a workaround for you.

First, please consider creating a Custom connector, by describing the API you want to connect to, the connector understands the API’s operation and data structure.

More details about Custom connector:

https://docs.microsoft.com/en-us/connectors/custom-connectors/define-blank

Second way is combing with PowerApps. If you are also familiar with PowerApps, you could add a button with Launch function to open the file. Then a flow with PowerApps button trigger to collect data from PowerApps to save to SharePoint list.

I have made the following test for your reference.

Set up the flow likes below:

Add the flow on the button, and set the button’s OnSelect property with the following statement. Then once the current user clicks the button to open the file, his info will be recorded into SharePoint list as well.

Launch("https://xxxxx.sharepoint.com/:x:/r/Test4Testing/_layouts/15/Doc.aspx?sourcedoc=%7Ba432e102-681e-47bb-a0ec-71fe2fe37ec2%7D&action=default&uid=%7BA432E102-681E-47BB-A0EC-71FE2FE37EC2%7D&ListItemId=239&ListId=%7BF8790D59-D66E-4920-8B7B-2D186DE300B8%7D&odsp=1&env=prod");'PowerApp->Createitem'.Run(User().Email)

Best regards,

Mabel

Was this reply helpful? Yes No