When passing a parameter to an Azure Data ADF pipeline from Power Automate: Failed: The expression 'pipeline().parameters.EmailTo.EmailFrom' cannot be evaluated because property 'EmailFrom' cannot be selected.

Question

I am trying to create a generic ADF Pipeline that:

1. Is called from Power Automate (using Create a Pipeline Run)
2. Has an EmailFrom parameter (type object), that is passed from Power Automate
3. Converts EmailFrom parameter (object) to var_email variable (string)
4. Using Web Activity, calls a Logic App to send an email using the var_email variable

This is how my Power Automate "Create a Pipeline" parameter looks like

This is how I convert EmailFrom parameter (Object) to var_email variable (string) using "Set Variable" step in pipeline

@pipeline().parameters.EmailTo.EmailFrom  

When I call the ADF Pipeline from Power Automate, I get the following error in the Pipeline Runs

However, when I use "Debug" mode in ADF Pipeline, passing the same parameter

The email is successfully sent and received without any issues.

How can I use the parameter passed from Power Automate to convert to string, and pass on to Logic App? What am I doing wrong here?

Cheers,
VT

Answer 1

Hi @Gaultz ,

Thank you for posting query in Microsoft Q&A Platform.

I see there is a small mistake which you are doing. You should be using your pipeline parameters inside parameters of "Create pipeline run" logic app step.

Please check below images where I implemented similar thing and it was working for me.

Pipeline Implementation:

Create pipeline Run step inside Power Automate:

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators