Answered

How To Exclude Filtered Values From File in Sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

Sundeep_Malik 6,501 on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Link copied!

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

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

Like (1)

Report
Copy link

Link copied!

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

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Link copied!

No I don't believe you need those steps.

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

Like (0)

Report
Copy link

Link copied!

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

Link copied!

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