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

(1) Share

Report

Posted on by lsheltonSTO1

113 Most Valuable Professional

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
lsheltonSTO1 113 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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"

Was this reply helpful? Yes No
lsheltonSTO1 113 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
lsheltonSTO1 113 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
lsheltonSTO1 113 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
lsheltonSTO1 113 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No