cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marcopolo2000
New Member

SQL connector output and replace it with parameter?

Hi 🙂

I have some sort of problem , and i do not know if i should dig in more or maybe it is not possible to solve. I have a quite big flow that is working and will be used as an template which will be used in other cases , so to do it easy to change i have parametrized almost everything ,...except for one.

As you can see , im cycling through output from a SQL query to get specific fields labeled as 'LegalEntityId' . The value provided in append action is taken from the output of SQL from 'value' .

marcopolo2000_1-1602141337471.png

 

What i want to achieve is to instead of using this dynamic value  use a value from parameter that is handling the same value 'LegalEntityId' 🙂

 

marcopolo2000_0-1602142139173.png

 

 

something similar to this , but working one 🙂

"Append_to_array_variable": {
                        "inputs": {
                            "name": "SQL_BI__Raw_Fields",
                            "value": "@items('For_each_-_update_SQL_BI_Raw_fields_with_actual_fields')?@{parameters('SelectQuery')}"
                        },
                        "runAfter": {},

 

 

Pls help 🙂

0 REPLIES 0

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (39,147)