Send file share link via SMTP mail when a file is created in OneDrive

(0) Share

Report

Posted on by personalcompute

I'm new to Power Automate and I can't figure this out. What I'm trying to do is:

A) When a file is created in OneDrive folder, a share link is created.

B) Depending on which folder the new file was created, send the file share link via SMTP mail to different receipients.

The issues I'm facing are:

1) My folder in OneDrive is not recognised as folder but as file. When I create an OneDrive step, my folder doesn't show up in that step in [ *Folder -> Show Picker ] but it is available in [ *File -> Show Picker ].

2) How do I pass the share link for this newly created file to be used in mail in latter step?

3) I'm using [ Switch ] to differentiate folder path with the intention stated in B). As I test my flow, the Case was not triggered because the folder path obtained in the [ Switch ] step was some random characters eg. ahGRD5kJFD and the folder path I specified in [ Case -> *Equals ] is /Root/New Folder

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

You will need something like this logic:

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report
For the folder path:
You will see this because the file path is encoded to base64:
Use an expression to see the file folder path by using decodeBase64(FilePath)

decodeBase64(triggerOutputs()?['headers/x-ms-file-path-encoded'])

This returns the file path as human readable:

Ellis

Was this reply helpful? Yes No
personalcompute 12 on at

Like (0)

Report

Thank you. Using the Substring funstion, I was able to extract only the folder path.

Was this reply helpful? Yes No
personalcompute 12 on at

Like (0)

Report

Thank you. It works smoothly. Do you have any idea why one of my folder is not listed in the first step [When a file is created -> *Folder ]?

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

>>>Do you have any idea why one of my folder is not listed in the first step [When a file is created -> *Folder ]?
Can you send a screenshot of the trigger action:
In the example above, any file created within the Books folder or any subfolders under Books should trigger the flow.
There are some constraints: Files larger than 50 MB will be skipped and not returned by this trigger. Files moved within OneDrive are not considered new files.

See: OneDrive for Business When a file is created

Ellis

Was this reply helpful? Yes No
personalcompute 12 on at

Like (0)

Report

File Directory

The folder I'm intended to use is "Kimeda".

Folder shown in Step

The folder "Kimeda" is not shown in the Step's Picker.

I tried using other Step previously, couldn't remember what was the Step name, "Kimeda" was available in the Picker but the icon beside it was "File icon" instead of "Folder icon" as shown.

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

In File Explorer, what status icons are shown for the folder:
Are there any documents within the Kimeda folder?
Another test: close the flow, re-name the folder to Kimeda1, wait and allow the change to sync, then edit the flow again and see if the folder Kimeda1 appears as a selectable folder.
Ellis

Was this reply helpful? Yes No
personalcompute 12 on at

Like (0)

Report

That folder contains few sub folders and documents. The total folder size is over 50MB.
However the Step trigger is to create a file no larger than 50MB within that folder, so maybe there's a limit to folder size as well?

Was this reply helpful? Yes No