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,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

@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,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

Sure, see below @ScottShearer

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

Like (0)

Report
Copy link

Link copied!
@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
Copy link

Link copied!

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

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

Like (0)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

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

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

Like (0)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

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

Any idea why?!

The official documentation is really bad.

Was this reply helpful? Yes No