Answered

Collection showing results from lookup column

Like (0) Share

Report

Posted on 23 Feb 2022 20:12:22 by WoodworkingDad

I have a collection colUtilityFacCodes which has 4 results which are tables and the inside each result is a single line table which is a lookup column in dataverse. I am trying to get colUtilityFacCodes to show the value in cr578_facility... for each result or something like:

Any help is appreciated.

I have the same question (0)

All responses (3)

Answers (1)

WoodworkingDad 27 on 23 Feb 2022 at 21:51:06

Like (1)

Report

Re: Collection showing results from lookup column

I think i might have figured it out. I needed to use AddColumns(source, column, Result.'Facility Code' This seems to work. Thanks!

Was this reply helpful? Yes No
WoodworkingDad 27 on 23 Feb 2022 at 21:29:34

Like (1)

Report

Re: Collection showing results from lookup column

@TheRobRush Thanks, I am so very close! I made the gallery work perfectly but how can I get the values into a collection and display just like the gallery?

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,123 Moderator on 23 Feb 2022 at 20:33:48

Like (1)

Report
Re: Collection showing results from lookup column

In this example I have a Collection called TicketSurvey, inside each row has a nested table in a column titled questions, and one of the columns in it is titled question.

Placing the following

Ungroup(TicketSurvey,"Questions")

In the items property of a gallery and thisitem.question in its label will give me a gallery that shows every question nested in the original gallery. see below example

Was this reply helpful? Yes No