Using macro to edit filter

adm510

Hi all,

I created a macro that connects to our SharePoint Online instance and generates a list of files and folders in a particular folder.  At the end of the workflow, I added a drop down to allow users to filter the results: Both Files & Folders, Files Only, or Folders Only.  In my data stream, I have a variable [type] which is indicates if it is a file or folder, and this is what I would like to filter on. Unfortunately after a few different attempts, I'm not sure how to construct my formula.

I attached a simple version of this workflow and was hoping someone could take a look at it for me.

I tried using the following formulas in the action tool and wrote this:

IF [#1]="both" THEN
	1
ELSEIF [#1] = "files" THEN
	"[type] = files"
ELSEIF [#1] = "folders" THEN
	"[type] = folders"
ELSE
	0
ENDIF

It doesn't seem right that I put [type] in quotes

IF [#1]="both" THEN
	1
ELSEIF [#1] = "files" THEN
	[type] = "files"
ELSEIF [#1] = "folders" THEN
	[type] = "folders"
ELSE
	0
ENDIF

Both of these formulas failed, and I'm not sure what other steps I can take to resolve this.

EDIT:

I decided to go another route and set the value of the drop down to a variable, then that way I could use [type] in my formula, but now I'm getting error messages about how "both" is an unknown variable. Maybe it's the formula/drop down list that messing me up.  This attempt is formula macro2.yxzp

formula macro.yxzp

formula macro2.yxzp

Joe_Mako

I think the attached is what you are looking for.

Notice that the Drop-Down interface element is directly connected into the Filter tool's "Q" input, and the wire/line is named "Filter", this name can be set by clicking on the wire/line, and in the configuration window setting the name.

Then in the Formula tool, there is a new variable section called "Connections from Questions", this is that "Q" input, and we can see "Filter" there, and it will be a string, ready to use i your expression.

If the value you were passing into the "Q" should be a number, would would need to wrap it in a ToNumber() function.

Edit: Also your expression could be simplified to just:

[Filter] = "both" OR [type] = [Filter]

macro jm edit.yxmc