Set Select action Map dynamically?

(2) Share

Report

Posted on by alex_mcla

Is is possible to have the Select action Map as the output from a previous step or to process an array into the Map?

I have an array:

[
 "Story",
 "Bug"
]

And my current Select action and Map is

Where the map is

[
 item()?['Story'],
 item()?['Bug']
]

I'm wanting to use the same flow with different arrays as the array is extracted from a FetchXML query.

Is it possible to transform the array into an expression that can be used in the map?

I have the same question (0)

All responses (3)

Answers (0)

NGS2410 5 on at

Like (0)

Report

Re: Set Select action Map dynamically?

I need this too...
I need to create a Map dynamically. I am creating a json like this:
{
  "linx_vo_factorysalesorder": "@{item()[A]}",
  "linx_jli_joblineitemnumber": "@{item()[B]}",
  "linx_jli_job": "@{item()[D]}",
  "linx_vo_requesteddate": "@{item()[G]}",
  "linx_vo_scheduledshipdate": "@{item()[H]}",
  "linx_vo_actualshipdate": "@{item()[I]}",
  "linx_eli_description": "@{item()[K]}",
  "linx_vo_carrier": "@{item()[O]}",
  "linx_vo_pro": "@{item()[P]}",
  "linx_eli_qty": "@{item()[L]}"
}

But it does not work:
[
  {
    "linx_vo_factorysalesorder": "@{item()[A]}",
    "linx_jli_joblineitemnumber": "@{item()[B]}",
    "linx_jli_job": "@{item()[D]}",
    "linx_vo_requesteddate": "@{item()[G]}",
    "linx_vo_scheduledshipdate": "@{item()[H]}",
    "linx_vo_actualshipdate": "@{item()[I]}",
    "linx_eli_description": "@{item()[K]}",
    "linx_vo_carrier": "@{item()[O]}",
    "linx_vo_pro": "@{item()[P]}",
    "linx_eli_qty": "@{item()[L]}"
  },
  {
    "linx_vo_factorysalesorder": "@{item()[A]}",
    "linx_jli_joblineitemnumber": "@{item()[B]}",
    "linx_jli_job": "@{item()[D]}",
    "linx_vo_requesteddate": "@{item()[G]}",
    "linx_vo_scheduledshipdate": "@{item()[H]}",
    "linx_vo_actualshipdate": "@{item()[I]}",
    "linx_eli_description": "@{item()[K]}",
    "linx_vo_carrier": "@{item()[O]}",
    "linx_vo_pro": "@{item()[P]}",
    "linx_eli_qty": "@{item()[L]}"
  },
  {
    "linx_vo_factorysalesorder": "@{item()[A]}",
    "linx_jli_joblineitemnumber": "@{item()[B]}",
    "linx_jli_job": "@{item()[D]}",
    "linx_vo_requesteddate": "@{item()[G]}",
    "linx_vo_scheduledshipdate": "@{item()[H]}",
    "linx_vo_actualshipdate": "@{item()[I]}",
    "linx_eli_description": "@{item()[K]}",
    "linx_vo_carrier": "@{item()[O]}",
    "linx_vo_pro": "@{item()[P]}",
    "linx_eli_qty": "@{item()[L]}"
  },
  {
    "linx_vo_factorysalesorder": "@{item()[A]}",
    "linx_jli_joblineitemnumber": "@{item()[B]}",
    "linx_jli_job": "@{item()[D]}",
    "linx_vo_requesteddate": "@{item()[G]}",
    "linx_vo_scheduledshipdate": "@{item()[H]}",
    "linx_vo_actualshipdate": "@{item()[I]}",
    "linx_eli_description": "@{item()[K]}",
    "linx_vo_carrier": "@{item()[O]}",
    "linx_vo_pro": "@{item()[P]}",
    "linx_eli_qty": "@{item()[L]}"
  },
  {
    "linx_vo_factorysalesorder": "@{item()[A]}",
    "linx_jli_joblineitemnumber": "@{item()[B]}",
    "linx_jli_job": "@{item()[D]}",
    "linx_vo_requesteddate": "@{item()[G]}",
    "linx_vo_scheduledshipdate": "@{item()[H]}",
    "linx_vo_actualshipdate": "@{item()[I]}",
    "linx_eli_description": "@{item()[K]}",
    "linx_vo_carrier": "@{item()[O]}",
    "linx_vo_pro": "@{item()[P]}",
    "linx_eli_qty": "@{item()[L]}"
  },
  {
    "linx_vo_factorysalesorder": "@{item()[A]}",
    "linx_jli_joblineitemnumber": "@{item()[B]}",
    "linx_jli_job": "@{item()[D]}",
    "linx_vo_requesteddate": "@{item()[G]}",
    "linx_vo_scheduledshipdate": "@{item()[H]}",
    "linx_vo_actualshipdate": "@{item()[I]}",
    "linx_eli_description": "@{item()[K]}",
    "linx_vo_carrier": "@{item()[O]}",
    "linx_vo_pro": "@{item()[P]}",
    "linx_eli_qty": "@{item()[L]}"
  }
]

Was this reply helpful? Yes No
wetscott 2 on at

Like (0)

Report

Re: Set Select action Map dynamically?

Ever end up solving this?

I too have a similar task. I have a list of columns sitting in an array, and want to pass these to a Select to dynamically create my Key:Value pairs for my CSV file, where each Value should =
"@split(item(), ',')?[0]" (where dynamically replaced based on the index of the column.

Was this reply helpful? Yes No
Androj1 6 on at

Like (0)

Report

Re: Set Select action Map dynamically?

Hello, did anyone find a solution to this problem? I'd like to use the dynamic value from the previous action in the select's map field.

Was this reply helpful? Yes No