Connecting Data From Two SharePoint Lists - DropDown Output and Form Control

[lsheltonSTO1]

Hello all,

I am trying to build a form where I have a dropdown with a list of goals (trimmed by the person who entered the goal, which I've got set up).  When a person selects a goal from the dropdown, I'd like that goal to be populated in a form control.

The problem is that the form control is going to belong to a second source (both SharePoint lists, both will have a column named Goal).  I want the contents of the dropdown selection to fill into the first data card in the form control, so that when the user fills out the rest of the fields, the goal will match with what they selected from the first list.

This is the formula I have that isn't working now (darn you, Chat GPT!).  The two lists are called OKRGoals and OKRActions, and the two columns are both called Goal.

Your help would be appreciated.  Thank you in advance!

[CNT]

@lsheltonSTO1 Filter will return a table but what you need is a single record in the default property of the Dropddown. So, replace the Filter with a LookUp.

Please remember to give a 👍 and accept my solution as it will help others in the future.

[lsheltonSTO1]

I tried that, and I'm still getting the same error I was getting on the Filter formula that wasn't working (which I should have shared) - "Expected Text value"

[lsheltonSTO1]

For more context, the OnSelect of the dropdown has this: Set(varGoal,Dropdown1.SelectedText.Value), so I'm reasonably confident that varGoal is text.

[CNT]

@lsheltonSTO1 LookUp will not return Text Value. You have to narrow it down to the field which has the Text Value,

e.g LookUp('OKRActions', OKRGoals.Goal=varGoal, yourTextColumn)

Please remember to give a 👍 and accept my solution as it will help others in the future.

[lsheltonSTO1]

Okay, so that got rid of that error, but now varGoal is a text value and OKRGoals.Goal is a table, so there's an error because the two types don't match.

Thank you in advance for being patient with me!

[CNT]

@lsheltonSTO1 What are the field in OKRActions SP List and their Data Type?

[lsheltonSTO1]

Both fields are renamed Title fields - Goal and both are therefore single line of text fields.

[CNT · Accepted solution]

@lsheltonSTO1 if that's the case, LookUp('OKRActions', Goal=varGoal, Goal) should retun a Text.

[lsheltonSTO1]

I didn't have any data in the 2nd SharePoint list and that was causing the error.  Thank you so much!