how to auto hyperlink based on the title and time as a button in gallery?

(0) Share

Report

Posted on by bbsin

1,994

I like to get help on how to autolink the hyperlink from SP list based on the title and date into the gallery.

Currently the gallery show items that has been booked by users

I have a admin list in SP , that I like to input the hyperlink for the event log in and how to enable it to auto pick into the gallery based on the event title and date , it should only appear on the date itself at 6am for user to click and log into the event only that day. can someone help. thank you

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Ashwin7104 671 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @bbsin - Please include the below code in log into event-> On select

Launch(Thisitem.EventLinkLogin)

And add below code in button DisplayMode

If((TimeValue(Text(Now())) > Time(6,00,00)) && (DateDiff(ThisItem.EventStartDate,Now(),Days) = 0),Edit,Disabled)

I assume EventStartDate is Date column in SharePoint.
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbsin

Edited. The solution is needed to visible or enable the link/button. In the below example, the link is visible 10 minutes before the event.

Set the visible property of button/link/icon to

(DateDiff(TimeValue(Text(Now())),TimeValue(ThisItem.EventTimeStart),Minutes) > -10) && (DateDiff(ThisItem.JustDate,Now(),Days) = 0)

Or displaymode
If((DateDiff(TimeValue(Text(Now())),TimeValue(ThisItem.EventTimeStart),Minutes) > -10) && (DateDiff(ThisItem.JustDate,Now(),Days) = 0),Edit,Disabled)
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply

Sorry I just release that the dashboard is displaying registered who had booked from the SP list -Activities Overall'
There an admin list where by the organizer will input the link when they book is there any way to input the link inside the admin SP list and it will auto pick into the booking side in the dashboard once they have booked that will appear in the button?

or I have to input link into the overall one by one?

Not sure how this works. Thanks

What is the best way to do it? Thank you
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Another SP list has an Event URL. So OnSelect of the button in the Gallery
Launch(LookUp(AdminSPList,ID=First(ThisItem.ColumnNameLinktoOtherSPList).Id).ColumnURL)

In this example,
Launch(LookUp(EventIItinerary,ID=First(ThisItem.Event).Id).EventLogin)

EventIItinerary - Admin SP list has a URL
ThisItem.Event - Column Name that lookup to Admin SP
EventLogin - Name of the column contains URL

The above code works perfectly.
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy

Thank not too sure how the link from the admin to the other side work..
do I need to have it link up first?

1) Admin Use list - administrator will input but how does it link back to the record to match with it's booked??
User first booked and record will display in dashboard.

2) Why is the department not pick up from the book record of user??

Thank you