Microsoft Lists, Sharepoint, column with multiple values reference different columns

%3CLINGO-SUB%20id%3D%22lingo-sub-3341845%22%20slang%3D%22en-US%22%3EMicrosoft%20Lists%2C%20Sharepoint%2C%20column%20with%20multiple%20values%20reference%20different%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3341845%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20need%20some%20help%20with%20what%2C%20to%20me%2C%20seems%20complicated.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E'm%20new%20to%20sharepoint%20and%20I%20have%20to%20create%20this%20excel%20table%20%3A%20(%20values%20enter%20by%20the%20user%20so%20I%20dont%20know%20how%20many%20perimiters%20nor%20expected%20results%20he%20will%20add%20)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22help.PNG%22%20style%3D%22width%3A%20773px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370117i23CF0EB5BED66A54%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22help.PNG%22%20alt%3D%22help.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20column%20%22Project%22%20and%20that%20project%20is%20associated%20to%20some%20%22Expected%20results%22%2C%20the%20%22expected%20results%22%20has%20diferrent%20%22perimeters%22%20and%20each%20perimeter%20has%20his%20own%20%22Unit%20price%22%20%2C%22Quantity%22%20...%20etc%3C%2FP%3E%3CP%3EI%20created%20this%20%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22help2.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370118i03AF19FEFCC9CD5C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22help2.PNG%22%20alt%3D%22help2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ebut%20you%20can%20see%20the%20problem%20here%20%3A%26nbsp%3B%20I%20can%20only%20add%20one%20value%20to%20the%20perimeter%20column%20(only%20one%20unit%20price%20and%20one%20quantity...)%2C%20I%20can't%20add%20different%20values%20with%20different%20prices%20and%20quantities.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20you%26nbsp%3B%20think%20is%20the%20best%20solution%20to%20create%20the%20same%20excel%20table%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3341845%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EApp%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3342639%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Lists%2C%20Sharepoint%2C%20column%20with%20multiple%20values%20reference%20different%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3342639%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1384610%22%20target%3D%22_blank%22%3E%40Dohazh%3C%2FA%3E%26nbsp%3BI%20think%20you'll%20need%20to%20do%20this%20with%20Power%20Apps%20where%20you%20could%20have%20a%20dropdown%20for%20the%20parameter%2C%20and%20depending%20what%20was%20selected%20the%20appropriate%20unit%20price%20and%20quantity%20would%20be%20added.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3343039%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Lists%2C%20Sharepoint%2C%20column%20with%20multiple%20values%20reference%20different%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3343039%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20answer%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3E%3CBR%20%2F%3EHow%20can%20I%20use%20a%20dropdown%20for%20perimeter%20because%20it's%20a%20user%20input%20%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3343085%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Lists%2C%20Sharepoint%2C%20column%20with%20multiple%20values%20reference%20different%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3343085%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1384610%22%20target%3D%22_blank%22%3E%40Dohazh%3C%2FA%3E%26nbsp%3Bif%20you%20don't%20know%20how%20many%20parameters%20there%20are%20going%20to%20be%20then%20there%20is%20no%20way%20for%20any%20app%20to%20look%20up%20what%20the%20quantity%2C%20unit%20price%20etc%20should%20be.%20If%20you%20have%20all%20the%20parameters%20in%20your%20app%20then%20it's%20straightforward%20but%20unless%20you%20know%20what%20those%20are%20there%20is%20no%20way%20it%20can%20look%20up%20the%20related%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need some help with what, to me, seems complicated.

'm new to sharepoint and I have to create this excel table : ( values enter by the user so I dont know how many perimiters nor expected results he will add )

help.PNG

 

I have a column "Project" and that project is associated to some "Expected results", the "expected results" has diferrent "perimeters" and each perimeter has his own "Unit price" ,"Quantity" ... etc

I created this :

help2.PNG

but you can see the problem here :  I can only add one value to the perimeter column (only one unit price and one quantity...), I can't add different values with different prices and quantities. 

 

What do you  think is the best solution to create the same excel table ?

 

3 Replies

@Dohazh I think you'll need to do this with Power Apps where you could have a dropdown for the parameter, and depending what was selected the appropriate unit price and quantity would be added.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Thank you for your answer @RobElliott
How can I use a dropdown for perimeter because it's a user input ?

@Dohazh if you don't know how many parameters there are going to be then there is no way for any app to look up what the quantity, unit price etc should be. If you have all the parameters in your app then it's straightforward but unless you know what those are there is no way it can look up the related data.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)