Manipulating array using Get Metadata and If activity

Question

Manipulating array using Get Metadata and If activity

Tarun Sharma 0

@contains(activity('Get Metadata1').output.childItems,'SalesLT.Customer.txt' )

Why If activity expression is resulting in False? With Get Metadata I am trying to get all files in the Source folder. And if "SalesLT.Customer.txt" exists in the folder, I want to insert data in the Azure sql table.

Can an array element be required to checked with For loop and for each interaction check if a file exists within that ?

Tarun Sharma 0 Reputation points

2023-03-09T15:22:00.9466667+00:00

This is the pipeline
KranthiPakala-MSFT 35,101 Reputation points Microsoft Employee

2023-03-11T16:07:20.9766667+00:00

@Tarun Sharma Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 35,101 Reputation points Microsoft Employee

2023-03-15T23:29:59.08+00:00

@Tarun Sharma We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

Tarun Sharma 0 Reputation points

2023-03-09T15:22:00.9466667+00:00

This is the pipeline
KranthiPakala-MSFT 35,101 Reputation points Microsoft Employee

2023-03-11T16:07:20.9766667+00:00

@Tarun Sharma Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 35,101 Reputation points Microsoft Employee

2023-03-15T23:29:59.08+00:00

@Tarun Sharma We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

Answer 1

Hi @Tarun Sharma ,

Welcome to Microsoft Q&A forum and thanks for reaching out here.

Why If activity expression is resulting in False?

The reason always the IF condition enters false path is because as per your dynamic expression (@contains(activity('Get Metadata1').output.childItems,'SalesLT.Customer.txt' )) , you are passing @activity('Get Metadata1').output.childItems which is an array type to @contains function. But @contains() function expects a string as input argument and then looks for provided substring exits or not. This is the reason why it always enters false path.

Resolution: In order to convert the array type to string you can use @String() function and it should help convert your childItems from array to a string type.

To do so please use below dynamic expression and it should help resolve your issue.

@contains(string(activity('Get Metadata1').output.childItems),'SalesLT.Customer.txt' )

Hope this helps.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Manipulating array using Get Metadata and If activity

1 answer

Activity