Unanswered

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

(0) Share

Report

Posted on by 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

Categories:

General topics

I have the same question (0)

All responses (14)

Answers (0)

v-liwei-msft on at

Like (0)

Report
Copy link

Link copied!

You don't need to use parse json.

I have made a test for your reference:

Best Regards,

Levi

Hi @AlexPowerApps

Was this reply helpful? Yes No
AlexPowerApps 50 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
AlexPowerApps 50 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
AlexPowerApps 50 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!
Hi @AlexPowerApps,
instead of outputs('cognomeMod') try to use
item()?['cognomeMod']

Was this reply helpful? Yes No
AlexPowerApps 50 on at

Like (0)

Report
Copy link

Link copied!

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....

Was this reply helpful? Yes No
AlexPowerApps 50 on at

Like (0)

Report
Copy link

Link copied!

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....

Was this reply helpful? Yes No
AlexPowerApps 50 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Your understanding is wrong, sorry.
Could you provide the output of compose action that contains cognomeMod?

Was this reply helpful? Yes No
AlexPowerApps 50 on at

Like (0)

Report
Copy link

Link copied!

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 🙂

Was this reply helpful? Yes No