Save Forms Attachment to Specific OneDrive Folder

(0) Share

Report

Posted on by jonboylib

114

I have a very simple form with two questions;

Category (dropdown list)

- cat01

- cat02

- cat03

Attachment (file upload)

When the form is submitted I am using a flow to generate an approval, this works as expected. See image of current working flow.

Screenshot 2022-03-30 143705.png

After the approval is true, I want to save the attachment to a specific folder in my OneDrive. e.g.

if ms form category == cat01 then save to My Docs/stuff/cat01

if ms form category == cat02 then save to My Docs/stuff/cat02

if ms form category == cat03 then save to My Docs/stuff/cat03

I am using OneDrive for business.

How can I achieve this?

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@jonboylib

It looks like you have everything figured out except how to save the files to a specific OneDrive folder.

Here is a link to a blog post that explains how

The blog post saves the file to SharePoint - just substitute a OneDrive for Business create file action for the SharePoint create file action.

Obviously you'll need a condition to determine to which folder you will save the files.

Was this reply helpful? Yes No
jonboylib 114 on at

Like (0)

Report

@ScottShearer Thanks, I now have most of it working. I am able to create the file as you have suggested, however when I add a condition to check for the form 'Budget Code' it always fails.

I am checking if the 'Budget Code' is equal to '6987 - Equipment'. This is a string type variable (varBudgetCode) I set earlier in the flow.

Any ideas why it's not working? See images below.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@jonboylib

Can you post a screen shot of your condition in edit/design mode?

Was this reply helpful? Yes No
jonboylib 114 on at

Like (0)

Report

Sure, see below @ScottShearer

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report
@jonboylib

Can you do the following please:

Add a compose action immediately after the Get file metadata action

set the compose action equal to the varBudget variable

Run the Flow and post a screen shot of the run that shows the Compose action outoput

Also, I said to add a condition but you could have used a switch action as well.

Was this reply helpful? Yes No
jonboylib 114 on at

Like (0)

Report

I've done that, see image below @ScottShearer Still returning false.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@jonboylib

Try putting the variable reference in your condition inside of a trim() expression

Also try deleting 6987 - Equipment in your expression and re-entering it.

Was this reply helpful? Yes No
jonboylib 114 on at

Like (0)

Report

I've added it inside a trim as you can see, still fails @ScottShearer

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@jonboylib

Please add trim() to the left side of your condition and test

Was this reply helpful? Yes No
jonboylib 114 on at

Like (0)

Report

@ScottShearer adding a trim on both sides worked - thanks!

Any idea why?!

The official documentation is really bad.

Was this reply helpful? Yes No