cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kileyohl
Regular Visitor

UPDATED: Link item in concat string on detail screen to clicked item's detail screen using different SPO Datasource by modifying "With" function used to concat string from SPO Lookup column.

Project:
Basic Conference Agenda PowerApp

Datasources:
Multiple Sharepoint Lists 
List 1: "Sessions" List for the event data (title, date/time, description, & Lookup column pulling list of presenters for that session from the Sessions List)  (*See attached PDF Pg 1)
List 2: "Presenters" List for Presenters Data

Details:
List 1 (Sessions) has SP Lookup column pulling in multiple-select List-2 (Presenter) records. It currently displays text data fine, but want user to be able to click on an individual presenter's name while on the Sessions detail screen and have it take them to that presenter's detail page. (Think of the behavior of going to a WP Blog Site where on the post, there is a clickable link going to the 'author page' so you can see all of their articles.)

Add'l Specifics:
  • For the moment, I'm only trying to solve this for the "Sessions Detail" screen (assuming staying focused there will provide a scalable fix to other screens/views)(*See attached PDF Pg 3)
  • I have changed the DataCardValue items property to not use Choices function and converted to using With function (thinking it may give me a way to somehow wrap a Navigate function around the names in the concatenated string with a little more control). Both of these functions work, with identical output, but thought using With will better prepare it for manipulation needed to add navigation options. Both items property function values are below for reference. (*See attached PDF Pg 5)

My actual "help me!" request is this:

Can anyone assist with how/where to modify the function below to 'wrap' each of the names output in the string with a clickable way to take the user from the Session Detail page to the respective person-clicked's Presenter Detail page?

 

 

 

With(
    {
        presentersString: Concat(
            SessionsBrowseGallery.Selected.PresentersLookup.Value,
            Value,
            ", "
        )
    },
    With(
        {
            presentersFormatted: Mid(
                presentersString,
                1,
                Len(presentersString)
            )
        },
        Split(
            presentersFormatted,
            ","
        )
    )
)

 

 

UPDATED:

Think we are close! THANK YOU SO MUCH Shane Young for your suggestion. It didn't break anything, but items still aren't clickable. I DO think we are SO close, though! Any other suggestions or tweaks are welcomed and appreciated!

 

Shane's suggestion:

Screen Shot 2020-09-24 at 2.14.51 PM.png

 

1 REPLY 1
summitb
Power Participant
Power Participant

Glad that you're problem is resolved.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (14,430)