Answered

Autopopulate Multiselect cmb from Sharepoint List

(0) Share

Report

Posted on by ksullivan2

Hi,

I want to filter timesheet phasecodes based on the phasecode categories that have been pertinent to an employee. I have 3 sharepoint lists.

1. Phasecodes - "test" column - text, the phase code category

2. Employees - "PC Group" lookup to Phasecodes "test", multiselect, all the groups hte employee should have access to

3. Timesheets list and form - I want employees to only see phasecodes where the pc groups selected next to their names = the phasecode 'test' column.

Since the phase code groups are predetermined based on the employee list, I was going to add the pc groups to a field on the form that is not visible, and then filter. But since multiselect lookup is a table, I can't get it to populate anything. Idk, any thoughts would be appreciated. Thanks

timesheet:

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @ksullivan2 ,

Where would you like to filter the timesheet phasecodes? If the Combo box is within a Gallery, then you can get the result from Employee List directly.

Items of Combo box:

Choices('Employee List'.'PC Group')

DefaultSelectedItems:

LookUp('Employee List', Name = ThisItem.Employee, 'PC Group')

and you can display phasecodes easily, using a concat function in a Label's Text property:

Concat(LookUp('Employee List', Name = ThisItem.Employee, 'PC Group'),Value, ","

Best regards,

Was this reply helpful? Yes No
ksullivan2 84 on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni

These instructions make sense, but the lookup isn't working because it's trying to compare two different data types.

What about doing a lookup on the VPID instead? It's still two data types, text and lookup, but maybe it might be easier somehow.

Here's a better breakdown of what is happening:
Employee List
Timesheet List in Sharepoint
Power app form - Gallery in a container,

For testing purposes, I have an extra screen I added that has a gallery for the employee list. I was brainstorming ways to filter from this gallery to the gallery on the timesheet app, but came up with nothing.

Another idea I was thinking of what to add the PC group to the collection I'm using in the timesheet app. But I wasn't able to figure out how to add a lookup column from another list to that collection

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @ksullivan2 ,

The Employee: VP ID column seems like an associated LookUp column. This kind of columns are basically used in SP list to display an associated column for the main LookUp column. In your case, it should be the Employee column. But actually, you can also find the Employee list Name column using the LookUp function, just need to make a little change:

Concat(LookUp('Employee List', Name = ThisItem.Employee.Value, 'PC Group'),Value, ",")

The incompatible data types error is due to the Employee LookUp column of the criteria 'Name = ThisItem.Employee', and we can make it specific to the Value field of LookUp:

Name = ThisItem.Employee.Value

Best regards,

Was this reply helpful? Yes No
Verified answer

ksullivan2 84 on at

Like (0)

Report
Copy link

Link copied!

Good news, I solved it with the following:
Items: LookUp('Employee List', 'Name' in cmbEmployees.SelectedItems.Value).'Phase Category Groups'
DefaultSelectedItems: Same as Items

Then in the phasecode Items, I changed it to this:
Filter('RAS PhaseCodes', 'Phasecode Category' in cmbTimesheetPC.SelectedItems.Value)

I'll need to redo the formulas for delegation warnings, but at least they work now! Thanks for the ideas and insights

Was this reply helpful? Yes No