Filter Choice look up field

[Anonymous]

I hope I can explain my issue clearly. I'm new in Power Apps so... here it is my issue.

I have 2 lists in SharePoint.

1. Master event catalog named 'Marketing_EventCatalog' .... aka Events

2. Guest check-in named 'Marketing_GuestCheckIn'... aka Guest

(I will use the aka names just to not write the whole name every time I'm referencing the list)

The Guest list has 2 columns.

1. Event Name - This is a lookup column to the Event list, it brings the ID, which the ID in the Event list is a concatenation of Event - Date - Market.

2. Guest Name

The Events list has 4 columns

1. Event Name 

2. Event Date

3. Event Market

4. isActive - This is a "Yes" or "No" choice.... CHOICE not True or False field.

In my Power App, I have an initial screen, to select the Market, with the name 'Dropdown1'.

This is my struggle. Every time a user wants to select a market in the Guest list, the dropdown is as big as all the Events IDs in the Events List. What I need is to Filter this combo box so it only shows events in the Market selected in the 'Dropdown1' and that are currently Active ("Yes" on column Active in Event list).

I have tried to change the formula in Items for the Event Name Lookup column to

Filter( Marketing_EventsCatalog, 'Event Market'.Value = Dropdown1.Selected.Value && Active.Value ="Yes").'Event ID'

And it actually works, it only shows me the events in the selected market that are currently active.

The issue is that after I tested it, when I save the record I go to my SharePoint and in the event field in the Guest list, is null as if I didn't choose anything.

I'm guessing it has to do that the options that I'm filtering are coming from the Event list and I'm trying to write a lookup column in the Guest List.

Please I need help.

Note, this is Canvas App (I don't know if that matters)

[WarrenBelz]

Hi @Anonymous ,

Assuming 'Event Name' is a Text (Single line of Text) column in your data source, you need to change the Update property of the DataCard in which the 'Event Name' drop-down is located to

DataCardValue8_1.Selected.'Event ID'

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Anonymous]

@WarrenBelz Hi,

Thanks for your answer, the Event Name in my Guest list, is a lookup value of 'Even ID' on my Event list.

[WarrenBelz]

Thanks @Anonymous ,

I will give you the answer first - this is the Update of the DataCard

{
   '@odata.type': "Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
   Id:DataCardValue8_1.Selected.ID,
   Value:DataCardValue8_1.Selected.'Event ID'
}

then ask does this really need to be a lookup column if all the input is done in Power Apps?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[v-siky-msft · Accepted solution]

Hi @Anonymous ,

From my view, the Update property of Data Card should be like this, since the Items of combobox is single-column table.

LookUp(Choices('Marketing_GuestCheckIn'.'Event Name'),Value=DataCardValue8_1.Selected.'Event ID')

Hope this helps.
Sik

[WarrenBelz]

Thanks @v-siky-msft , that is another view on updating a Lookup column.

@Anonymous you did say the target column in your data source was a lookup column?

[Anonymous]

@WarrenBelz 

I will test this and will let you know.

And to answer the question, NO, it doesn't, it's just how the SharePoint list was setup at the begining.

And yes it's. Lookup column

[Anonymous]

@WarrenBelz  I must have done something wrong, it did not work.

I tried your solution @v-siky-msft  and it did the trick. 

Thank you both very much!!! You practically saved my life !! lol