Link Correct Event ID in Participant Form in Power Apps

(0) Share

Report

Posted on by danielahvist

I am currently working on a Power Apps application that is connected to two SharePoint lists:

* One for events

* One for participants

My goal is to link the 'Event' field in the participant form directly to the 'Event name' in the event form. However, I am encountering an issue due to events having identical names but different IDs.

The problem arises when I attempt to add a new participant through the "New+" button in the participant list. While the event name populates correctly in the associated field, the ID does not correspond to the correct event. It seems to only link to one instance of the repeated event names, thus not reflecting the actual event I need.

SelectedEvent (SelectedEvent is a global variable within the icon arrow in event gallary) shows the correct event ID.

But when I test the ID with a text label it shows a different event ID

I need guidance on how to ensure that the 'Event' field in the participant form correctly references the event's unique ID, not just its name, especially when there are multiple events with the same name. How can I achieve this linkage accurately in Power Apps?

Any advice or solutions would be greatly appreciated. Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @danielahvist ,

The LookUp function starts looking from the top of the list for the first item that matches the criteria, stop looking and return found item. So if you are using the same name multiple times, always the first item with that name will be returned.

Changing the condition in the LookUp function to use the ID column will fix the issues since that has unique values. Also you can use the Coalesce function to cover the functionality of the If function to get a slightly cleaner formula:

Coalesce( Parent.Default, LookUp( DropdownValues.Participants.Event, ID = SelectedEvent.ID ) )

Was this reply helpful? Yes No
danielahvist 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Ah! Thank you so much! That worked 😁

Was this reply helpful? Yes No