Flow Designer not able to populate a field

practice test
Tera Contributor

Hi everyone, 

I created a flow designer that opens to Microsoft Intune devices and updates ServiceNow cmdb_ci_computer table. 
I am having issue populating model id field and its a reference field. Here is an example:

cmdb_ci_computer has a field model id, and it looks like Dell Inc. Latitude 3420
Intune is returning model id like this model_id=Latitude 3420

I am thinking about concatenating manufacturer field with model_id to populate the field value but I don't know how.  Model id field accepts only one corresponding field so I can't just add it there. I think I need to use a script to concatenate? What syntax would be managed devices variables?  

 

1 ACCEPTED SOLUTION

Allen Andreas
Administrator
Administrator

Hello,

If it's consistent in sending the model id in that format and you firmly trust the manufacturer will have the right information to add to it and it all matches exactly, every time, then you'd need to use the script feature to set the value for that field, it the code button next to the field value in your screenshot, click it and you'll see what I'm saying.

With that said, you'd need to use script like this:

var manu = fd_data. //then dot-walk to the manufacturer pill that holds that value
var modID = fd_data. //then dot-walk to the model id value
return manu + " " + modID;

Once you type fd_data and press . you'll see the dot-walk capability show up and you can walk to the your record that way. Again, try, and you'll see what I'm talking about.

The above is a rough example. Please take it from here.

Please mark reply as Helpful/Correct, if applicable. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

View solution in original post

1 REPLY 1

Allen Andreas
Administrator
Administrator

Hello,

If it's consistent in sending the model id in that format and you firmly trust the manufacturer will have the right information to add to it and it all matches exactly, every time, then you'd need to use the script feature to set the value for that field, it the code button next to the field value in your screenshot, click it and you'll see what I'm saying.

With that said, you'd need to use script like this:

var manu = fd_data. //then dot-walk to the manufacturer pill that holds that value
var modID = fd_data. //then dot-walk to the model id value
return manu + " " + modID;

Once you type fd_data and press . you'll see the dot-walk capability show up and you can walk to the your record that way. Again, try, and you'll see what I'm talking about.

The above is a rough example. Please take it from here.

Please mark reply as Helpful/Correct, if applicable. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!