Unanswered

Two SharePoint lists - Employees and Positions - how to assign?

(1) Share

Report

Posted on by PBInonpro

100

I have a list of all positions and then a list of all employees. I want to be able to select an employee and assign a position to them. So far I have two galleries, one for each list, and two forms, one for each list.

On the EmployeeForm I have a "Search Position" ComboBox with the Items: Distinct(Positions, SearchPosition). It seems to work, but when I go to edit the form from the gallery select, it doesn't load.

Example, if "John Doe" is assigned "Position - Front Desk" it will save onto the SharePoint list, but when I select 'edit' from the gallery, that field doesn't load.

What is the best way to approach this?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

hey @PBInonpro

what do you mean by does not load? is it empty or what?

Was this reply helpful? Yes No
PBInonpro 100 on at

Like (1)

Report
Copy link

Link copied!

Yes, sorry. When I select a record from the gallery to edit all the fields load except this one. it is blank, but in SharePoint on the list, the data is there. I am assuming I need to do a lookup, but i can't figure out a formula.

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

What kind of columntypenis the empty field and whats the column name?

Was this reply helpful? Yes No
PBInonpro 100 on at

Like (1)

Report
Copy link

Link copied!

On the Positions list I have a column called "ConCatPosition" which has all the unique values to make the position unique (Position ID, Title, etc).

On the Employees List I have a column renamed to "PositionID".

What should happen, is on the Employee form, you have the option to select from a ComboBox the "position" for that employee.

Positions: ConCatPosition = Calculated
Employees: PositionID = Text

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

select the datacard that has no value and check the Default property of it.

if its empty put ThisItem.ColumnName (replace with the name of your column)

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
PBInonpro 100 on at

Like (1)

Report
Copy link

Link copied!

No that isn't it, i tried that and it is good. I troubleshoot it down to the 'defaultselecteditems' of the combobox. Since it is pulling in data from the Positions list but the form has data from the Employees list, this is the disconnect.

I Have "Lookup(Positions, ConCatPosition = Parent.Default.PositionID) but I am getting an error since "PositionID is of type text.

Was this reply helpful? Yes No