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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,219)