Need some help nesting ShowColumns into a formula

(0) Share

Report

Posted on by dlprentice

628

Community,

I am not sure how to properly nest in ShowColumns into the below formula:

SortByColumns(
 Filter(
 AddColumns(
 'ESN Ticket Tracker',
 "City",
 LookUp(
 'Networking Device List Master',
 'DNS Entity Name' = 'ESN Ticket Tracker'[@cj7y],
 City
 ),
 "State",
 LookUp(
 'Networking Device List Master',
 'DNS Entity Name' = 'ESN Ticket Tracker'[@cj7y],
 State
 )
 ),
 Status = 'Status Dropdown'.SelectedText.Value,
 If(
 'All States Checkbox'.Value = false,
 State = 'State Dropdown'.SelectedText.Value,
 State = State
 ),
 If(
 'All Cities Checkbox'.Value = false,
 City = 'City Dropdown'.SelectedText.Value,
 City = City
 )
 ),
 "Created",
 Descending
)

Any help is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@dlprentice

Can you explain what it is that you are trying to accomplish and why you need to use ShowColumns in your scenario?

Your formula, as-is, needs a couple of adjustments to begin with:

SortByColumns( Filter( AddColumns( 'ESN Ticket Tracker' As _item, "City", LookUp('Networking Device List Master', 'DNS Entity Name' = _item.cj7y, City ), "State", LookUp( 'Networking Device List Master', 'DNS Entity Name' = _item.cj7y, State ) ), Status = 'Status Dropdown'.SelectedText.Value && // This should be changed to not use the deprecated SelectedText property ('All States Checkbox'.Value || State = 'State Dropdown'.SelectedText.Value) && // This should be changed to not use the deprecated SelectedText property ('All Cities Checkbox'.Value || City = 'City Dropdown'.SelectedText.Value) ), "Created", Descending )

You should change your formula to not use the SelectedText property as it is deprecated.

Was this reply helpful? Yes No
dlprentice 628 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Randy,

I appreciate you setting me straight on my formula 🙂

Basically each item displayed on the data table is hyperlinked to a different page so more details can be displayed for the selected item.

All of this seems pretty standard, but I can't display all of data I'd like to because the table isn't loading all of the data unless I add its column (at least it doesn't appear as though it is being loaded into context...). So my goal is to have additional data displayed that I'd like to not display and clutter up on the main page.
I would do a "Display", "Forms", but I am unsure of how to place the output of the data table into a collection to feed into the Form as a data source. If you have some ideas on whether or not using labels vs Forms with collection in this case is the best option please elaborate if willing.

Hopefully this is a clear and detailed response!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@dlprentice

As for options,

- Forms are much easier to works with.

- Collections stay away from them! You don't need them unless you need an in-app database for some reason. Your app already has all the data...why duplicate it again into a collection?

Now, what I am confused on - in your initial post you were adding two columns. I am understanding better now that you want these to display in the Gallery as well as the detail screen.

The reason (as I gather) is that these columns do not exist in your data record from 'ESN Ticket Tracker'

Is that a correct assumption?

If so, then based on that, I would provide added records to the Items property of the Gallery for the record from the other datasource that has all the values you need. These will be considered "read only" from here forward, so if you are also needing to be able to edit those values, then let me know that as well.

Was this reply helpful? Yes No
dlprentice 628 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
-Yes forms are easy, good point!
-Correct, I am adding two columns because they do not exist in 'ESN Ticket Tracker', and do exist in 'Networking Device List Master'.

I don't quite understand the last part of your reply. Would this be the ShowColumns() so that these can be loaded into context? Would this be on the first page (the one with all the records listed) or the details page? I can provide more details if that will help.

The original formula I pasted is the Items of the data table.

Was this reply helpful? Yes No
dlprentice 628 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

I know you are busy but, would you mind elaborating on this part? Maybe an example?

If so, then based on that, I would provide added records to the Items property of the Gallery for the record from the other datasource that has all the values you need. These will be considered "read only" from here forward, so if you are also needing to be able to edit those values, then let me know that as well.

Was this reply helpful? Yes No
Verified answer

dlprentice 628 on at

Like
a
(0)

Report
Copy link

Link copied!

Following up to answer my own question. I didn't need to use ShowColumns() adding additional columns allowed me to accomplish what I was trying to accomplish. I didn't realize ShowColumns() drops other columns.

Was this reply helpful? Yes No