Auto Populate columns based on a selection in Sharepint List

%3CLINGO-SUB%20id%3D%22lingo-sub-1433721%22%20slang%3D%22en-US%22%3EAuto%20Populate%20columns%20based%20on%20a%20selection%20in%20Sharepint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433721%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20List%20that%20has%20a%20lot%20of%20columns.%20I%20am%20wondering%20if%20there%20is%20a%20way%20for%20columns%20to%20be%20auto%20populated%20based%20on%20what%20the%20users%20select%20in%20another%20column%3F%3C%2FP%3E%3CP%3EChoice%20Column%201%20-%20User%20selects%20%22ABC%22%3C%2FP%3E%3CP%3EChoice%20Column%202-5%20auto%20populates%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1433721%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433831%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Populate%20columns%20based%20on%20a%20selection%20in%20Sharepint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433831%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F352640%22%20target%3D%22_blank%22%3E%40Tbruns%3C%2FA%3E%26nbsp%3Bthere%20are%202%20ways%20to%20do%20this.%20If%20you%20create%20a%20lookup%20column%20that%20looks%20up%20a%20column%20from%20a%20different%20list%20then%20you%20can%20select%20the%20data%20from%20any%20of%20the%20other%20columns%20in%20that%20second%20list%20to%20be%20added%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22lookupColumnsAdditionalFields.png%22%20style%3D%22width%3A%20405px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195940i0716D49B54C3D64B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22lookupColumnsAdditionalFields.png%22%20alt%3D%22lookupColumnsAdditionalFields.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20other%20way%20would%20be%20to%20use%20a%20Power%20Apps%20customised%20form%20instead%20of%20the%20default%20SharePoint%20form%20that%20would%20bring%20back%20the%20other%20columns%20from%20something%20selected%20in%2C%20for%20example%2C%20a%20dropdown%20and%20then%20patched%20(saved)%20to%20the%20SharePoint%20list.%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%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433898%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Populate%20columns%20based%20on%20a%20selection%20in%20Sharepint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433898%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20quick%20response.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20use%20the%20lookup%20column%2C%20will%20that%20work%20with%20the%20same%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20just%20started%20experimenting%20with%20PowerApps%20and%20actually%20have%20created%20the%20%22form%22%20in%20Powerapps%20and%20added%20it%20to%20my%20SharePoint%20page%20and%20I%20am%20using%20Collect%20then%20patch%20to%20send%20the%20info%20to%20the%20Sharepoint%20List.%20So%20basically%20I%20am%20saying%20I%20wouldn't%20know%20where%20to%20even%20start%20to%20get%20it%20to%20bring%20back%20the%20info%20after%20selecting%20certain%20criteria%20lol.%20It%20also%20seems%20to%20me%20that%20there%20is%20a%20lot%20of%20%22functions%22%20or%20%22Coding%22%20you%20have%20to%20do%20in%20PwerApps%20which%20I%20am%20far%20from%20a%20programming%20guru.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20you%20feel%20is%20the%20easiest%20for%20a%20novice%20like%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have a List that has a lot of columns. I am wondering if there is a way for columns to be auto populated based on what the users select in another column?

Choice Column 1 - User selects "ABC"

Choice Column 2-5 auto populates


Thank you

2 Replies
Highlighted

@Tbruns there are 2 ways to do this. If you create a lookup column that looks up a column from a different list then you can select the data from any of the other columns in that second list to be added:

lookupColumnsAdditionalFields.png

 

The other way would be to use a Power Apps customised form instead of the default SharePoint form that would bring back the other columns from something selected in, for example, a dropdown and then patched (saved) to the SharePoint list.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott 

Thank you for the quick response.

 

If I use the lookup column, will that work with the same list?

 

I have just started experimenting with PowerApps and actually have created the "form" in Powerapps and added it to my SharePoint page and I am using Collect then patch to send the info to the Sharepoint List. So basically I am saying I wouldn't know where to even start to get it to bring back the info after selecting certain criteria lol. It also seems to me that there is a lot of "functions" or "Coding" you have to do in PwerApps which I am far from a programming guru.

 

What do you feel is the easiest for a novice like me?