Answered

Property selection is not supported on values of type 'String'

(1) Share

Report

Posted on by FreddieJoseph1

Hi all,

I recently created a flow to email anyone who appears in an excel column to tell them they've got an overdue item. But I get this error message in my Filter Array: The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@equals(items('Apply_to_each')?['PSM (HUB)'], items('Apply_to_each'))' failed: 'The template language expression 'equals(items('Apply_to_each')?['PSM (HUB)'], items('Apply_to_each'))' cannot be evaluated because property 'PSM (HUB)' cannot be selected. Property selection is not supported on values of type 'String'.

I was following this suggestion: Send users single email with multiple Excel rows (Power Automate) . Is there anyway I can change the property type so it isn't a string?

Here is my entire flow:

Many thanks in advance,

Freddie

Categories:

Building flows

Power Automate Desktop

General topics

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

MS.Ragavendar 6,955 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@FreddieJoseph1,

The issue might be the Mail column which you referring in the excel might be having any non valid email format for e.g., Instead of the string it might have number column because of that filter array might not be possible.

Can you please share the output of the compose table, how the data is available for the property eMail.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

1 people found this reply helpful.

Was this reply helpful? Yes No
FreddieJoseph1 28 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply @MS.Ragavendar. Please see screenshots. I believe they're email addresses. They're hyperlinks in the spreadsheet.

Was this reply helpful? Yes No
FreddieJoseph1 28 on at

Like (0)

Report
Copy link

Link copied!

Sorry @MS.Ragavendar - your suggestion has worked. Thank you so much! I just had to do some refreshes. Really appreciate it!

Was this reply helpful? Yes No