Skip to main content

Hi

I am building an expense claim form where the GL Code displays depending on which expense type is selected. I'm trying to use the list lookup control and it needs to be in a repeating section as there may be more than one expense.

So far I have list lookup control for the Expense Type and a calculated field for the GL Code but I can only return the item ID

 

186045_pastedImage_1.png

 

Appreciate any help

 

Thanks,

Jesse

The list lookup runtime function to use within the calculated field isn't available in Forms for Office 365 as yet - vote for it here to Add Lookup Runtime Function – Customer Feedback for Nintex

Two options really

1. Get data after the fact via a workflow, but it won't be displayed on the form at time of entry

2. For the List Lookup drop down, base the column that shows on a calculated column which is the Expense Type + GL Code so users can see what they are selecting. You could then use some javascript to split this into fields on the form if you wanted to

Maybe 3rd Option - if you ca dev javascript REST calls to query sharepoint data, but this can get complex depending on setup of auth in your Office 365 tennat.


Reply