Power Platform Community Forum Thread Details

Thank you for taking the time to read my question.

I have a flow working but now need to add another filter to my "List rows" step

Today I have a condition that determines if dates are sent. If they are, then I have a "List rows" that has contains ODATA filter in the "Filter rows" field for date and AssetType, if not, then I only filter on AssetType.

I now need to add an additional filter on Region. In my PowerApps the regions a user has access to are in a comma separated list "East, West, Central, USA". I can pass this string as a string, or I could pass it as a Collection which would result in an array in Power Automate.

The flow creates a csv which is then turned into a file using "Create file 2".

What is the best way to pass the potential list of Regions to Flow so that I can filter my "List rows" step? (A user can have 1 or many regions assigned to them)

My Current "Parse JSON" step:

{
 "type": "object",
 "properties": {
 "AssetTyp": {
 "type": "string"
 },
 "WarEndDt": {
 "type": [
 "string",
 "null"
 ]
 },
 "WarStDt": {
 "type": [
 "string",
 "null"
 ]
 },
 "tUser": {
 "type": "string"
 }
 }
}