Share
Report
544I have a Power Automate Workflow that uses 2 SharePoint lists.
The first list, someone completes a form and there is a choice field called “Learning Sessions” with possible values of “Emergency Medicine”, “Family Medicine”, and “Pediatrics”.
The person selects “Emergency Medicine” and “Family Medicine”.
I append to an array variable called arrSessions. When I compose arrSessions I see this when I run the flow:
[
{
"Value": "Emergency Medicine"
},
{
"Value": "Family Medicine"
}
]
Enter my second list.
I’m trying to get the appropriate department email for each department. When I do a get items for this with no filter query, I return every item in the list like you would expect, when I append to a string variable strPrimaryEmailAddress.
When I hard code in Department eq ‘Emergency Medicine’ for the filter query it returns the email address for that department.
When I put in Department eq ‘Output’, meaning the compose results from my array up above, the append to string variable gets skipped.
I’ve checked in list 1 - Emergency Medicine, Family Medicine, etc are all spelled the same way. Both lists have them as choice fields.
I’ve been staring at this for a couple of hours. Anyone have any thoughts?
All responses (
Answers (
