Unanswered

Create a task in planner and add file from sharepoint

(0) Share

Report

Posted on by CU27101555-0

Good afternoon,

I created a flow that will add a new task to Planner, and name it after a file in a sharepoint folder. Basically, I have to create a bunch of planner tasks, name them the same name as files in sharepoint, then attach that file. I have successfully created the task and named it after the file, but I can't figure out how to get that file attached. I will be dropping multiple files in at a time, so each task needs the associated file attached. Any ideas? So I drop five files in the sharepoint folder, 5 tasks are created, each named after each file, then attached that corresponding file. Here is what I have:

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @dw_22801,

You can use a Update task details action for this. In that action you can set a reference like a link to a file. You just need to collect the file path.

Btw, it looks like you are using a deprecated trigger action. Which I wouldn't recommend using.

Below is an example

1. Place a Get file metadata using path action directly after the trigger action

a. Use the expression below to use the x-ms-file-id property value and decode the characters which are encoded (like the / slash)

replace(replace(triggerOutputs()?['headers/x-ms-file-id'], '%252f', '/'), '%2b', ' ')

2. Place a Update task details action at the end

a. Use the id of the Create a task action

b. Use the File Name variable in the Reference Alias

c. Use the expression below as the hyperlink to the file. In concatenates the site address and the relative file path values together

concat(trigger()['inputs']['parameters']['dataset'], outputs('Get_file_metadata_using_path')?['body/Path'])

Was this reply helpful? Yes No
CU27101555-0 on at

Like (0)

Report

Thanks! Is there not a way to just replace the deprecated action, or delete it and add a new one in place? Can actions only be added at the end? Surely I don't have to create an entirely new flow since I want to change the first action?

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @dw_22801,

You should be able to delete the trigger action and replace it with another one. However, the fields of that action which are used in other actions will also be removed. So, you would have to reconfigure settings of other actions as well, when you replace a trigger action.

Was this reply helpful? Yes No
CU27101555-0 on at

Like (0)

Report

Thanks!

Was this reply helpful? Yes No