cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Need help with flow : Move document set based on condition from excel field value (When Document library column value = Excel value )

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 structureFlow structure"The field is of type 'TaxonomyFieldType' cannot be used in the query filter expression. flow"The field is of type 'TaxonomyFieldType' cannot be used in the query filter expression. flow

Excel File:

 

Excel file valuesExcel file values

 

Regards,

Eswar

6 REPLIES 6
Highlighted
Dual Super User III
Dual Super User III

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted

Dear 

 

 

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

Highlighted
Dual Super User III
Dual Super User III

Hi again!
Just to make sure... you mean this type of column?
https://support.office.com/en-us/article/create-a-managed-metadata-column-8fad9e35-a618-4400-b3c7-46...

Thanks!


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted

Hi, 

 

Yes, it is a managed metadata column.

 

Regards,

Eswar T

 

Highlighted

PFA value.PFA value.

 

 

Highlighted
Dual Super User III
Dual Super User III

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Kudoed Authors
Users online (8,138)