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.
I used 'Filter Array' instead and it worked. Thanks for your help and appreciate your time.
I ran a little test and worked for me. Perhaps you should create a small test flow to get it to work first.
Hi @365-Assist , yes I did try without spaces as per my previous screenshots but that still didn't work. Attached same screenshot of the error below.
The filter will not handle title with spaces in excel. You need to remove the spaces. e.g. DELIVERYREGION.
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??
No I don't believe you need those steps.
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'?
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)
In SharePoint what kind of column is it (Text, Choice, ...)?
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
