Forum Discussion

nive1110's avatar
nive1110
Regular Visitor
3 years ago

Generate unique code in power Apps for different projects with descending order in sharepoint list

  Project Sub Project details Location   Unique Role ID(Project +sub proj +location +(Number )) E-Elec ABC Onsite   E-ElecABCOnsite-1 E-Elec ABC Offshore   E-ElecABCOffshore-1 ...
Need Help
Show and Tell
Tutorial Requests
nive1110's avatar
nive1110
Regular Visitor
3 years ago

Hi Anonymous  Need to generate uniique id using project, sub project and location with incremental order . 

 

how to generate unique role IDs for the different combinations of Project, Sub Project details, and Location:

 

For example

 

ProjectSub Project detailsLocation Unique Role ID Formula Used in "Unique Role ID"
E-ElecCCOnsite E-ElecCCOnsite-1 A2&B2&C2&"-1"
E-ElecCCOffshore E-ElecCCOffshore-1 A3&B3&C3&"-1"
E-ElecCCOffshore E-ElecCCOffshore-2 A4&B4&C4&"-2"
E-ElecABCOnsite E-ElecABCOnsite-1 A5&B5&C5&"-1"
E-ElecABCOffshore E-ElecABCOffshore-1 A6&B6&C6&"-1"
E-ElecABCOffshore E-ElecABCOffshore-2 A7&B7&C7&"-2"
E-ElecMailOnsite E-ElecMailOnsite-1 A8&B8&C8&"-1"
E-ElecMailOffshore E-ElecMailOffshore-1 A9&B9&C9&"-1"
E-ElecMailOffshore E-ElecMailOffshore-2 A10&B10&C10&"-2"
Rule 17.1 Onsite Rule 17.1Onsite-1 A11&B11&C11&"-1"
Rule 17.1 Onsite Rule 17.1Onsite-2 A12&B12&C12&"-2"
Rule 17.1 Offshore Rule 17.1Offshore-1 A13&B13&C13&"-1"
Rule 17.1 Offshore Rule 17.1Offshore-2 A14&B14&C14&"-2"
Rule 17.1 Offshore Rule 17.1Offshore-3 A15&B15&C15&"-3"
Rule 17.1 Offshore Rule 17.1Offshore-4 A16&B16&C16&"-4"
Rule 17.1 Offshore Rule 17.1Offshore-5 A17&B17&C17&"-5"
Rule 17.1 Offshore Rule 17.1Offshore-6 A18&B18&C18&"-6"
Rule 17.1 Offshore Rule 17.1Offshore-7 A19&B19&C19&"-7"
PIPP Onsite PIPPOnsite-1 A20&B20&C20&"-1"
PIPP Offshore PIPPOffshore-1 A21&B21&C21&"-1"
PIPP Offshore PIPPOffshore-2 A22&B22&C22&"-2"
PIPP Offshore PIPPOffshore-3 A23&B23&C23&"-3"
PIPP Offshore PIPPOffshore-4 A24&B24&C24&"-4"