Putting a people list inside of a company list

(0) Share

Report

Posted on by bjensen1

Hello there Microsoft family,

I am new to power apps and still figuring this out(hence why it looks like a 2nd grader built it).

I have a screen(that uses the people template), with company names on them. I have it set to navigate to another people screen where I want it to display very specific set of people based on what company I select.

The navigation to the 2nd screen works, however it doesn't display any information. I have it set to a different excel spreadsheet if that means anything. Although, there is a column where it lists the company. In SQL something close to excel1.company = excel2.company type thing.

Any ideas how i get my specific people to enter into each company?

The following are some functions input for context.

OnSelect of the arrows on the company page: Navigate(PeopleListScreen, ScreenTransition.None)

The individual boxes(blue boxes on "employee" screen): PeopleAddedGallery1.Selected (where PeopleAddedGallery1 is within the company page)

Thanks,

Categories:

Building Power Apps

people.png

comapnies.png

I have the same question (0)

All responses (7)

Answers (0)

VaidasG 469 on at

Like (0)

Report

Hi @bjensen1,

Why don't you create global variable for your selected company, and then use that value as the filter parameter form your 2nd gallery..!?

Hope this helps
Regards
VaidasG

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
bjensen1 21 on at

Like (0)

Report

A little update, I managed to get it to pull every name, but it isn't company specific. It is displaying everybody.

I am aware how weird this all sounds, please feel free to ask questions and I will try to answer the best I can.

Was this reply helpful? Yes No
VaidasG 469 on at

Like (0)

Report

@bjensen1

can you show you onSelect property content from companies gallery and Items property value from companies gallery?

Regards
VaidasG

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
bjensen1 21 on at

Like (0)

Report

Hey @VaidasG ,

My apologies, my computer didn't show your responses.

I am unfamiliar with global variables in here, again, new to this. Although I shall do my research.

The Items refers to the excel sheet it is using, no formula, just the sheet name.

The onselect shows False.

However the arrow onselect is Navigate(PeopleListScreen, None) ...... peoplelistscreen is the screen on which it should have the certain employees.

Was this reply helpful? Yes No
VaidasG 469 on at

Like (0)

Report
@bjensen1

let's try the following...

Arrow onselect change to:
Set(gblCompany, ThisItem);
Navigate(PeopleListScreen, None)

For the Items property of your People gallery:
Filter(yourExcelTableName, Company = gblCompany)

You might have to add additional values like Set(gblCompany, ThisItem.Name) or Filter(yourExcelTableName, Company.Name = gblCompany) as your data source will have columns that you will be referencing to...

Hope this helps
Regards
VaidasG

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
bjensen1 21 on at

Like (0)

Report

@VaidasG

Tried it out. Got the following in the checker, in regards to the items property, no issues on the arrow though.

Was this reply helpful? Yes No
VaidasG 469 on at

Like (0)

Report

@bjensen1

OK.. what happened here is that we try to compare Text (value) with whole Record (object)
you need to select the property of the Record object you try to compare to... Lets say gblCompany.Name

Hope this helps
Regards
VaidasG

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No