Skip to main content
Nintex Community Menu Bar
Solved

Get an item from dictionary with the look up field in the original collection


Forum|alt.badge.img+2

Hi,

 

Below is a sample of my collection returned in the Query list option in Nintex for Office 365. I am now looping through these items and trying to get the value of Title in the Tool array. What is the item path value  in get item from dictionary action? I tried various paths but nothing is working. I tried Tool(0)/Title but it doesn’t work. Please help.

 

 

 

Best answer by Garrett

Hi @rythm 

 

Since the value which you wish to retrieve is nested, try using 2 Get Item from Collection.

1st Get Item from Collection
Dict: v_dict
Item name: Tool
Output: v_tool   which should be {“Title”: ”Backend”}

2nd Get Item from Collection
Dict: v_tool  (result from 1st Get Item)
Item name: Title
Output: v_title    which should be “Backend”

Alternative to 2nd Get Item (if v_tool is return as string type and not as Dictionary/Collection type)
1st Search and Replace → {“Title”: ” with blank string “”
2nd Search and Replace → “}  with blank string “”
Final Result → Backend 

 

The alternative method is to use Regular Expression or Regex.
This is possible when there is a fix text structure   

View original
Translate
Did this topic help you find an answer to your question?

2 replies

Garrett
Forum|alt.badge.img+16
  • Scout
  • 904 replies
  • Answer
  • May 16, 2023

Hi @rythm 

 

Since the value which you wish to retrieve is nested, try using 2 Get Item from Collection.

1st Get Item from Collection
Dict: v_dict
Item name: Tool
Output: v_tool   which should be {“Title”: ”Backend”}

2nd Get Item from Collection
Dict: v_tool  (result from 1st Get Item)
Item name: Title
Output: v_title    which should be “Backend”

Alternative to 2nd Get Item (if v_tool is return as string type and not as Dictionary/Collection type)
1st Search and Replace → {“Title”: ” with blank string “”
2nd Search and Replace → “}  with blank string “”
Final Result → Backend 

 

The alternative method is to use Regular Expression or Regex.
This is possible when there is a fix text structure   

Translate

Forum|alt.badge.img+2
  • Author
  • Rookie
  • 6 replies
  • May 16, 2023

Hi Garett,

 

This approach worked beautifully. Thank you so much! 

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings