find a substring in a name field in an array of objects

[AlexPowerApps]

Hi,
I can't get my goal....I have several files inside a folder in onedrive busines and I used get files action to list them and after I used parse json action and finally converted in an array variable (array of objects) whose structure is:

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "Id": {
                "type": "string"
            },
            "Name": {
                "type": "string"
            },
            "NameNoExt": {
                "type": "string"
            },
            "DisplayName": {
                "type": "string"
            },
            "Path": {
                "type": "string"
            },
            "LastModified": {
                "type": "string"
            },
            "Size": {
                "type": "integer"
            },
            "MediaType": {
                "type": "string"
            },
            "IsFolder": {
                "type": "boolean"
            },
            "ETag": {
                "type": "string"
            },
            "LastModifiedBy": {
                "type": "string"
            },
            "FileLocator": {
                "type": "string"
            }
        },
        "required": [
            "Id",
            "Name",
            "NameNoExt",
            "DisplayName",
            "Path",
            "LastModified",
            "Size",
            "MediaType",
            "IsFolder",
            "ETag",
            "LastModifiedBy"
        ]
    }
}

 Then I would like to iterate throuh the output of the latest step (over my array variable) and check for each iteration if the name field of the current ojbect cointains a value of a compose action defined outiside the loop so that depeding on the result I can do some actions rather than other in case it doesn't match.
Example:
Suppose I have three files in an onedrive path:
file1_mode2.zip
file30_mart3.zip
dog_miller.zip
and my compose has value: miller
It means that at the third iteration by comparing the name parameter of my array (dog_miller.zip) with the compose value (miller) I should get true by using contains function, but I always get false.
Could someone help me out?
Thanks

[v-liwei-msft]

Hi @AlexPowerApps 

You don't need to use parse json.

I have made a test for your reference:

Best Regards,

Levi

[AlexPowerApps]

Thanks for getting back, but I had already tried and even if  I use the containes function any iteration is false ,but the filename contains the value of compose.. I also used toUpper to make it case insensitive..but nothing
Please see below:

[AlexPowerApps]

As addendum, I attached these two screenshots: To show that any iteration is false

I also tried to create two compose to see what values have...but contains function always gives false:

[AlexPowerApps]

I also tried to use indexof function, but nothing changes...I get -1 even if there is part of string that I am looking for..

Please any hint?

[VictorIvanidze]

Hi @AlexPowerApps,

instead of outputs('cognomeMod') try to use

 item()?['cognomeMod']

[AlexPowerApps]

Nothing happens...cognomeMod is a compose action outside the loop, so why do you want to call it via item() function?
Anyway, it seems very complicated to check a substring in a filename field of this array....

[AlexPowerApps]

I also tried another function: encodeUriComponent , if I put a hard-code string it finds the index as expected, while if I put or variable or compose whose value is 'Sottole' returns -1....so the issue is in the variable or compose outside the loop is just like not to be a string....

[AlexPowerApps]

I just reviewed the contains function and from my understanding, the second parameter must be a hard-coded string and not a variable or compose...Thus, I really don't know how to find in the Name parameter of an array of objects a substring based on a value of variable or compose action

[VictorIvanidze]

Your understanding is wrong, sorry.

Could you provide the output of compose action that contains cognomeMod?

[AlexPowerApps]

Yes, you're right because I'm testing out of my loop by defining another compose with a substring that I know is included in my filename and then I use contains function putting as the first parameter a simple string (it would be my filename) and the second parameter compose action. With cognomeMode compose action I get false (that's not true) while with compose_2 action I correctly get true... Below the difference between two compose actions:

Addendum after run the flow:

As you can see, the output of both compose are equal but if I use the CognomeMod compose as a second parameter in the contains function returns false (wrongly )...am I getting crazy 🙂

[AlexPowerApps]

I need to thank chatGPT 🙂 cause I explained my issue by reporting the code by code and he suggested using trim() for my CognomeMode compose and boom it returned me true :)... Now I need to replace the first parameter which is my hard-coded filename and give it a try inside the loop by calling the right parameter.I will try tomorrow and let you know

[v-liwei-msft]

Hi @AlexPowerApps 

According to the screenshot you provided, I suggest you to try the trim function.
The problem may be caused by filenames containing extra space characters.

I think this link will help you:

Trim and TrimEnds functions in Power Apps - Power Platform | Microsoft Learn

Best Regards,

Levi

[AlexPowerApps]

Yes, if you read my previous post I had found the issue by querying chatgtp..Now I have a small issue and I wanto to make my conditions case insensitive , but on the left side of the condition inside the loop I can't apply the following function: toLower(items('Applica_a_ogni_8')?['Name'])
How can I apply on both sides the toLower function to make it case insensitive?

[AlexPowerApps]

Update:
I found this solution: https://powerusers.microsoft.com/t5/Building-Flows/Change-file-attachment-name-to-lower-case-for-com...
I defined a compose action inside YES branch and follow the instructions of  @v-yamao-msft and now my conditions seem case insensitive, but to be honest is not clear the logic behind that ...I had tried ssame thing by defining the compose action outside the condition, but inside the loop and it said: out of scope...I would be curious if someone can explain why I need to do like that inside a condition .