Answered

Create/Update Project ID after Project is Created in SharePoint

(0) Share

Report

Posted on by jt1

I'm a SharePoint Online new user, and would like to get some help on this task.

We have a project list that allows user to create new project. SharePoint has internal ID assigned to each new project created, and I have another column called Project ID with empty value when ID is created.

What I want to achieve is to utilize Microsoft Flow to check if there is new item added to project list, then extract ID value and concat with preset field value and update Project ID column.

The challenge I'm getting is in 2 areas:

Let flow update Project ID for new item only, but not the whole list
Concatenate strings in the following format: 2 digit year + ID (3 digits). i.e. 17-003 (year 2017, ID is 3), by adding 2 zeroes in front of ID if it's single digit, or 1 zero if 2 digit. etc.

Any help would be highly appreciated!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yamao-msft on at

Like (1)

Report

Hi jt1,

Please consider to use the workflow definition language concat to see if it will work for you. More details about concat function, please see here:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

I create a simple flow to test this issue. The flow is configured likes following.

The flow is triggered by “When an item is created”.

In the action Compose2, I use concat function to combine the ID and year together.

The code is:
“@concat('17-','00',outputs('Compose'))”

Then in the action “Update item”, update the column ProjectID with the output of Compose2.

PS: When using the update item action, you will have to specify a value for the required fields.

Hope this could be a reference for you.

Please try it on your side.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
jt1 5 on at

Like (0)

Report

Hi Mabel,

Thanks a lot for taking the time to share your insights. I got it to work based on the suggestions, so your solution definitely works!

Now only if I can figure out padding zeros in front of ID to make it 3 digit string (i.e. ID 4 would be 004, and 23 would be 023), that'd be perfect. In formula I can use REPT function, but couldn't locate one similar to it in workflow definition language you referred.

Any thoughts on that?

Much appreciated!

Was this reply helpful? Yes No