cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lorem1960
Resolver II
Resolver II

Is Hyperlink in Gallery control?

Hi,

 

Isn't there a way to enable a hyperlink link in a gallery control (like you can do in a data table) so that when a user clicks on the field that it opens the screen that has the form details? I am looking for an elegant way so that when a user selects a record from within my Gallery that it then in turns opens another form that has detailed information about the record that was selected.

BTW,  I am relatively new to Power Apps. Thanks 

1 ACCEPTED SOLUTION

Accepted Solutions

okay works now, needed to put my gallery in Edit Mode - thanks a million for your help on this!!!

View solution in original post

8 REPLIES 8
RandyHayes
Super User
Super User

@Lorem1960 

You can put any control in your Gallery that you want for this, or you can simply have the user click on any part of the Gallery.

Either way, set the OnSelect action of the control or the Gallery to: 

   Set(glbCurrentRecord, ThisItem);  Navigate(yourDetailFormScreen)

 

Set your Form Item to glbCurrentRecord

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

When I enter glbCurrentRecord in my FormDetails I get this error message:

 

Lorem1960_0-1635353915895.png

 

RandyHayes
Super User
Super User

@Lorem1960 

Is your Gallery not based on the Datasource for your form??

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

In my Gallery I have this for my Items:

 

SortByColumns(
Filter(
AddColumns(
'Pending Procurement Receipts',
"StatValue",
Status.Value,
"SentValue",
'Email Sent'.Value
),
(IsBlank(SearchTextBox_1.Text) ||
StartsWith('PR #',SearchTextBox_1.Text) ||
StartsWith('Req. Office', SearchTextBox_1.Text) ||
StartsWith('Title (Title0)', SearchTextBox_1.Text) ||
StartsWith('Vendor Name', SearchTextBox_1.Text) ||
StartsWith('Receipt Status', SearchTextBox_1.Text) ||
StartsWith('Order Contact', SearchTextBox_1.Text) ||
StartsWith('Receipt Status', SearchTextBox_1.Text) ||
StartsWith(Response, SearchTextBox_1.Text) ||
StartsWith(Status.Value, SearchTextBox_1.Text)
) &&
(drpdwnOrderType_1.Selected.Result = "All" ||
'Order Type' = drpdwnOrderType_1.Selected.Result

)

&&
(drpdwnOrderStatus_1.Selected.Value = "All" ||
Status.Value = drpdwnOrderStatus_1.Selected.Value

)

&&
(drpdwnEmailSent_1.Selected.Value = "All" ||
'Email Sent'.Value = drpdwnEmailSent_1.Selected.Value

)

),

varSortColumn,
varSortDirection

)

 

Doing some sorting and filtering on my Gallery

RandyHayes
Super User
Super User

@Lorem1960 

Yes, you are adding a column in your Items - this will change the schema of the record - it should be dropped in the formula.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Not fixed yet, removed Addcolumn

 

SortByColumns(
Filter(
'Pending Procurement Receipts',


(IsBlank(SearchTextBox_1.Text) ||
StartsWith('PR #',SearchTextBox_1.Text) ||
StartsWith('Req. Office', SearchTextBox_1.Text) ||
StartsWith('Title (Title0)', SearchTextBox_1.Text) ||
StartsWith('Vendor Name', SearchTextBox_1.Text) ||
StartsWith('Receipt Status', SearchTextBox_1.Text) ||
StartsWith('Order Contact', SearchTextBox_1.Text) ||
StartsWith('Receipt Status', SearchTextBox_1.Text) ||
StartsWith(Response, SearchTextBox_1.Text) ||
StartsWith(Status.Value, SearchTextBox_1.Text)
) &&
(drpdwnOrderType_1.Selected.Result = "All" ||
'Order Type' = drpdwnOrderType_1.Selected.Result

)

&&
(drpdwnOrderStatus_1.Selected.Value = "All" ||
Status.Value = drpdwnOrderStatus_1.Selected.Value

)

&&
(drpdwnEmailSent_1.Selected.Value = "All" ||
'Email Sent'.Value = drpdwnEmailSent_1.Selected.Value

)

),

varSortColumn,
varSortDirection

)

 

and 

When I enter glbCurrentRecord in my FormDetails I get the same error.

Sorry.

 

okay works now, needed to put my gallery in Edit Mode - thanks a million for your help on this!!!

View solution in original post

RandyHayes
Super User
Super User

@Lorem1960 

You do not appear to be removing the column in the formula...it should be:

DropColumns(
    SortByColumns(
        Filter(
            AddColumns('Pending Procurement Receipts',
                "StatValue", Status.Value,
                "SentValue", 'Email Sent'.Value
            ),
            (IsBlank(SearchTextBox_1.Text) ||
            StartsWith('PR #',SearchTextBox_1.Text) ||
            StartsWith('Req. Office', SearchTextBox_1.Text) ||
            StartsWith('Title (Title0)', SearchTextBox_1.Text) ||
            StartsWith('Vendor Name', SearchTextBox_1.Text) ||
            StartsWith('Receipt Status', SearchTextBox_1.Text) ||
            StartsWith('Order Contact', SearchTextBox_1.Text) ||
            StartsWith('Receipt Status', SearchTextBox_1.Text) ||
            StartsWith(Response, SearchTextBox_1.Text) ||
            StartsWith(Status.Value, SearchTextBox_1.Text)
            ) &&
            (drpdwnOrderType_1.Selected.Result = "All" || 'Order Type' = drpdwnOrderType_1.Selected.Result) &&
            (drpdwnOrderStatus_1.Selected.Value = "All" || Status.Value = drpdwnOrderStatus_1.Selected.Value) &&
            (drpdwnEmailSent_1.Selected.Value = "All" || 'Email Sent'.Value = drpdwnEmailSent_1.Selected.Value)
        ),
        varSortColumn,
        varSortDirection
    ),
    "StatValue", "SentValue"
)

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,036)