Auto-populate a field in a SharePoint list based on values selected in two others

%3CLINGO-SUB%20id%3D%22lingo-sub-3011559%22%20slang%3D%22en-US%22%3EAuto-populate%20a%20field%20in%20a%20SharePoint%20list%20based%20on%20values%20selected%20in%20two%20others%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3011559%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20list%20with%203%20Columns%3A%20%3CSTRONG%3EUrgency%3C%2FSTRONG%3E%2C%20%3CSTRONG%3EImportance%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EPriority%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20auto-populate%20the%20%3CSTRONG%3EPriority%3C%2FSTRONG%3E%20column%20based%20on%20the%20values%20selected%20in%20%3CSTRONG%3EUrgency%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EImportance%3C%2FSTRONG%3E%2C%20either%20using%20some%20sort%20of%20calculated%20field%20or%20via%20PowerAutomate.%26nbsp%3B%20All%20three%20are%20currently%20set%20up%20as%20%3CSTRONG%3EChoice%3C%2FSTRONG%3E%20columns.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20anyone%20able%20to%20explain%20(in%20VERY%20basic%20steps)%20how%20to%20achieve%20this%20please%3F%20I%20have%20tried%20various%20things%20both%20using%20Power%20Automate%20(but%20am%20a%20real%20novice%20with%20this)%20and%20in%20SharePoint%20but%20to%20no%20success.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20specified%20below%20the%20text%20that%20should%20be%20displayed%20in%20%3CSTRONG%3EPriority%3C%2FSTRONG%3E%20depending%20on%20what%20has%20been%20selected%20in%20%3CSTRONG%3EUrgency%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EImportance%3A%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22208%22%3E%3CP%3E%3CSTRONG%3EIF%20Urgency%20is%3A%20%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3E%3CSTRONG%3EAnd%20Importance%20is%3A%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3E%3CSTRONG%3EThen%20Priority%20should%20be%3A%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22208%22%3E%3CP%3EHigh%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3ELow%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EMedium%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22208%22%3E%3CP%3EMedium%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3ELow%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3ELow%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22208%22%3E%3CP%3ELow%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3ELow%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3ELow%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22208%22%3E%3CP%3EHigh%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EMedium%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EHigh%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22208%22%3E%3CP%3EMedium%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EMedium%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EMedium%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22208%22%3E%3CP%3ELow%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EMedium%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3ELow%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22208%22%3E%3CP%3EHigh%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EHigh%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EHigh%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22208%22%3E%3CP%3EMedium%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EHigh%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EHigh%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22208%22%3E%3CP%3ELow%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EHigh%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E%3CP%3EMedium%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20be%20very%20grateful%20for%20any%20advice.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDamien%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3011559%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EConditional%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint.%20PowerAutomate%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3013314%22%20slang%3D%22en-US%22%3ERe%3A%20Auto-populate%20a%20field%20in%20a%20SharePoint%20list%20based%20on%20values%20selected%20in%20two%20others%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3013314%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1231483%22%20target%3D%22_blank%22%3E%40DamienR650%3C%2FA%3E%26nbsp%3Bthis%20is%20a%20perfect%20use%20case%20for%20looking%20into%20customizing%20your%20form%20with%20PowerApps.%20PowerApps%20allows%20you%20do%20create%20the%20kind%20of%20logic%20you%20describe.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20title%3D%22https%3A%2F%2Fblog.mydock365.com%2Fhow-to-customize-a-sharepoint-list-form-with-powerapps%22%20href%3D%22https%3A%2F%2Fblog.mydock365.com%2Fhow-to-customize-a-sharepoint-list-form-with-powerapps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fblog.mydock365.com%2Fhow-to-customize-a-sharepoint-list-form-with-powerapps%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi there, 

 

I have a SharePoint list with 3 Columns: Urgency, Importance and Priority.

 

I want to auto-populate the Priority column based on the values selected in Urgency and Importance, either using some sort of calculated field or via PowerAutomate.  All three are currently set up as Choice columns. 

 

Is anyone able to explain (in VERY basic steps) how to achieve this please? I have tried various things both using Power Automate (but am a real novice with this) and in SharePoint but to no success.

 

I have specified below the text that should be displayed in Priority depending on what has been selected in Urgency and Importance:

 

 

IF Urgency is:

And Importance is:

Then Priority should be:

High

Low

Medium

Medium

Low

Low

Low

Low

Low

High

Medium

High

Medium

Medium

Medium

Low

Medium

Low

High

High

High

Medium

High

High

Low

High

Medium

 

 

I'd be very grateful for any advice. 

 

Many thanks, 

 

Damien 

2 Replies

@DamienR650 this is a perfect use case for looking into customizing your form with PowerApps. PowerApps allows you do create the kind of logic you describe.

 

https://blog.mydock365.com/how-to-customize-a-sharepoint-list-form-with-powerapps