cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sajarac
Super User
Super User

Looking for an advice to start an app form scratch

Hi there,

Probably I had to ask this question a long time ago, but here is my scenario:

 

I would like to have all the app lists in Share Point.

I would like to keep consistence with MS Access, I mean, in one list have the products and in the main list have the product ID.

 

For instance:

 

SPL List Employees:

ID | Employee_Name

1 Employee A

2 Employee B

3 Employee C

4 Employee D

 

SPL Contract_Types

ID | Contracts

1 Full time

2 Part Time

3 Hourly

4 Salary

 

SPL Departments

ID | Department

1 HR

2 Maintenance

3 Production

 

Now I want to have my app connected to all those lists, and when the user select "ADD" new record, I want to see the comboboxes display the info for the "employees", "Contracts", "Department".

 

After that in the "Save" event I would like to save those choices in other SPL "Personal" but I would like to save the "ID's".

 

for instance if I choose:

Employee C | Full Time | Maintenance

In my SPL "Personal" should appear as:

Emp_ID   | Contract_ID  |  Department_ID

     3                  1                        2

 

That is the first part, now the second part is the "Personal Form". In this form I would like to perform "New", "Edit" "Save"

So this mean that the form "Personal" should read the share point list, when the user click in edit, it should bring the saved data in that record and also show the Comboboxes for a new selection or change. then Patch the record with the new values.

 

I am confused, I say videos where others users has SPL for the choices and then use the VLookup. other user has a SP column "Choices" with all the items required. But I think that this option is not good specially if you want to implement galleries to have the user creates new entries.

 

And in the other side, I don't know about performance, what about if my app have tons of records and all the time the app is doing lookups to present the data? 

 

Sorry probably too many questions but I wan to be sure to start good from the beginning.

 

Thanks in advance for any advice.

 

Best Regards

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

Hi @sajarac ,

Do you want to update Personal list with Id value, but display as text value?

Could you tell me the fields data type in four lists?
I assume that:
1)SPL List Employees: ID(number type), Employee_Name(text type)

2)SPL Contract_Types:  ID(number type), Contracts(text type)

3)SPL Departments:   ID(number type), Department(text type)

4)SPL Personal: Emp_ID(number type),Contract_ID(number type),Department_ID(number type)

 

If so, try this:

1)connect your app with these four lists

2)insert three drop downs

set drop down1's Items:

Distinct(Employees,Employee_Name)

set drop down2's Items:

Distinct(Contract_Types,Contracts)

set drop down3's Items:

Distinct(Departments,Department)

 3)the update formula:

Patch(Personal,Defaults(Personal),
               {Emp_ID:LookUp(Employees,Employee_Name=dropdown1.Selected.Result,ID),
                Contract_ID:LookUp(Contract_Types,Contracts=dropdown2.Selected.Result,ID),
                Department_ID:LookUp((Departments,Department=dropdown3.Selected.Result,ID)
               }
)

 

Do not need to worry about your app's performance when your data source is large.

The functions that I mention are all delegate for sharepoint.

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yutliu-msft
Community Support
Community Support

Hi @sajarac ,

Do you want to update Personal list with Id value, but display as text value?

Could you tell me the fields data type in four lists?
I assume that:
1)SPL List Employees: ID(number type), Employee_Name(text type)

2)SPL Contract_Types:  ID(number type), Contracts(text type)

3)SPL Departments:   ID(number type), Department(text type)

4)SPL Personal: Emp_ID(number type),Contract_ID(number type),Department_ID(number type)

 

If so, try this:

1)connect your app with these four lists

2)insert three drop downs

set drop down1's Items:

Distinct(Employees,Employee_Name)

set drop down2's Items:

Distinct(Contract_Types,Contracts)

set drop down3's Items:

Distinct(Departments,Department)

 3)the update formula:

Patch(Personal,Defaults(Personal),
               {Emp_ID:LookUp(Employees,Employee_Name=dropdown1.Selected.Result,ID),
                Contract_ID:LookUp(Contract_Types,Contracts=dropdown2.Selected.Result,ID),
                Department_ID:LookUp((Departments,Department=dropdown3.Selected.Result,ID)
               }
)

 

Do not need to worry about your app's performance when your data source is large.

The functions that I mention are all delegate for sharepoint.

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,906)