Answered

How To Exclude Filtered Values From File in Sharepoint

(0) Share

Report

Posted on by Community Power Pla...

Hi. I have existing flow that imports data from a sharepoint folder when a new file is created.

However, I need to add a condition that excludes a value from the "Delivery Region" column in the file. The value is "Others". How do I add this to the flow? Appreciate any help. Thanks.

Categories:

Using flows

I have the same question (0)

All responses (13)

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Anonymous

Why not add a condition before that get items that delivery region not equal to Others

if yes continue do what you are doing and in if no, leave it blank

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Sundeep_Malik thanks for the suggestion. I implemented but got an error. First screenshot showing the new added steps to the flow as suggested. Second screenshot showing the error. Am I missing something?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@365-Assist - do you have any thoughts on my issue please? Hope you don't me tagging you.

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report

In SharePoint what kind of column is it (Text, Choice, ...)?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi @365-Assist , the column DELIVERY REGION is a text column.

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report

Actually If I understand correctly you want to filter Delivery Region in the Excel File (Not SharePoint column).

If so try adding to the Filter in the Action List Rows present in Table.

Delivery Region ne 'Others' (You will have to adjust for exact syntax of the column)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yes your interpretation is correct i.e. filter from Excel file.

So I added filter in the 'List rows present in a table'. Do I leave the other 2 steps before the 'Get Items'?

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report

No I don't believe you need those steps.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Something weird is going on with the filter query - it's not recognizing the column name and keeps throwing error.

I tried Delivery Region as shown in Excel file and also tried DeliveryRegion but still same error. Also same issue when using all caps lock.

Am I missing something??

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report

The filter will not handle title with spaces in excel. You need to remove the spaces. e.g. DELIVERYREGION.

Was this reply helpful? Yes No