SharePoint Flow Formula

Question

Hi Experts,

Hoping someone out there can provide me with what the correct formula should be to write standard text & then add the ID to the end.

Example:

If Column1 has Entry of Either X or Y

Then

Always Write

CMNEM_

then

Append value in column1 to be

CMNEM_X

or CMNEM_Y

and then append the ID

So if ID was 1 & Column1 is Y expect to write to new column CMNEM_Y_01

or

IF ID was 2 & Column1 is X expect to write to new column CMNEM_X_02

Answer 1

Dear Paul,

It seems that you have posted a new thread for this issue on our forum.

I have replied to it and you can check the result and share your updates at your convenience.

Sharepoint Power Automate Formula Not Returning All Values - Microsoft Community

Meanwhile, I suggest you reenter the flow>change the end of the flow URL from true to false to change the flow into the classic mode and run the flow again to see whether the issue goes away from your side.

Your effort and time are greatly appreciated!

Sincerely

Cliff | Microsoft Community Moderator

Answer 2

Dear Paul,

It seems that the issue in your environment has been resolved.

Sharepoint Power Automate Formula Not Returning All Values - Microsoft Community

Thanks for your updates and kindness.

I'm glad to hear the good news.

If it is convenient, please also send your feedback as follows as it may benefit the community process.

![Image](https://learn-attachment.microsoft.com/api/attachments/974db0b7-94b8-41e6-98a0-665778d3aa15?platform=QnA

Answer 3

Thanks Cliff,

I applied as per your instructions and the flow ran successfully.

However, when I look at the field in the list it has not picked up the value of R from field classification. I got CMNEM_09 rather than the expected CMNEM_R_09

Answer 4

Dear Paul,

You can use the flow like the following.

New Column formula: concat('CMNEM_',outputs('Get_item')?['body/Column1/Value'],'_',outputs('Format_number')?['body'])

Result:

Welcome to share any updates when you have time if you need more help on this issue.

Your effort and time are greatly appreciated!

Sincerely

Cliff | Microsoft Community Moderator