Dear All,
My requirement is to move the document set, from one document library to another based on the condition from an excel sheet.
Flow Structure:
Flow structure
"The field is of type 'TaxonomyFieldType' cannot be used in the query filter expression. flow
Excel File:
Excel file values
Regards,
Eswar
Hi!
Some thoughts...
1.- do you want to move the entire folder or just the files you are trying to filter. If the answer is the second approach, then you should move them one by one (Apply to each, taking your array filtered as output)
2.- the error... it looks like the column type you are referencing in your Get Items filter is currently not supported in OData filter expressions... can you confirm which column type is defined in Sharepoint? are you using a LookUp Column? Maybe you need to remove OData filter expression from your Get items and add a Filter Array action block after Get items to filter its results. THere is an excellent thread describing this issue:
https://powerusers.microsoft.com/t5/Building-Flows/ODATA-Filter-queries-on-LookUp-columns-from-a-SP-...
Hope this helps
Proud to be a Flownaut!
Dear efialttes,
Thanks for the reply:
1) My document library has many document sets, based on the condition from the excel for example ( column value in excel = SID column in document library then move only that folder\document set).
2) The column type is metadata column in my document library and filter condition is SID = Column value of excel.
Kindly suggest me the approach or a sample flow with this query condition.
Regards,
Eswar T
Proud to be a Flownaut!
PFA value.
Hi again!
This thread discuss the same issue
https://powerusers.microsoft.com/t5/Building-Flows/Filtering-taxonomy/td-p/278941
Please note, if a metadata column value can be evaluated by means of a Condition action block, this means it can also be done by means of a Filter Array Action block
Another approach is to use "Send HTTP request to sharepoint, as discussed in this second thread:
https://sharepoint.stackexchange.com/questions/269433/filtering-on-managed-metadata-ms-flow
Hope this helps
Proud to be a Flownaut!
Make sure you are registered #MSBizAppsSummit #CommunityRocks
Check out new user group experience and if you are a leader please create your group
User | Count |
---|---|
24 | |
14 | |
12 | |
7 | |
6 |
User | Count |
---|---|
46 | |
22 | |
17 | |
15 | |
10 |