Unanswered

Email when a file changes

(0) Share

Report

Posted on by GuillermoTodd

A Power Automate flow was designed to email me when an Excel file from a SharePoint folder is changed, and it is is not working.

The flow starts with step" "Action 'When_a_file_is_modified'", and according to the Flow checker, this is the error:

{
  "status": 400,
  "message": "The file id 'https://company-my.sharepoint.com/:x:/r/personal/name_company_domain/_layouts/15/Doc.aspx?sourcedoc={29AE3A63-2982-4FDA-B7F0-D28A515E3FCF}&file=CRTracking.xlsx&action=default&mobileredirect=true' is not valid.",
  "source": "api.connectorp.svc.ms"
}

The file is valid and people are contributing to it online. The file was saved originally in my company's OneDrive folder, which is synced to SharePoint, and I can navigate to the file from the SharePoint format, so not sure what's going on here. Any insights or pointers are truly appreciated.

Thanks

-Guillermo

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

lbendlin 8,661 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

This file pointer is not usable - you need to get rid of the ":x:/r/" part, the _layouts part and a few other bits and bobs.

Use

https://company-my.sharepoint.com/personal/name_company_domain/CRTracking.xlsx

or a version with the appropriate subfolders.

Was this reply helpful? Yes No
GuillermoTodd 6 on at

Like (0)

Report
Copy link

Link copied!

How do I get a pointer that doesn't include drive letters, like ":x:/r/"?

This is an online file stored in my OneDrive and accessible through SharePoint, and it is meant for different people to collaborate on. When I generate a link to share, whether I open the file from the browser or Excel, the URL generated always includes drive letters.

Even when creating a brand new Excel file within my SharePoint site, the URL to share comes with drive letters.

Thanks,

-Guillermo

Was this reply helpful? Yes No
lbendlin 8,661 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The site URL should be a constant anyway. Use the file GUIDs instead of the names.

Was this reply helpful? Yes No