Power Platform Community Forum Thread Details

Hi All,

Hope all well.

I am creating a Team list (SharePoint) as a ticketing system for us to log a job when customer call for tech support. However, I have 2 issues which not able to resolve.. (I am not IT background.

1. When I create an item, I use the Formula to create a ticket ID, but every time when someone edit the list (or the ticket) it change the ticket ID. I am not sure what is the best way to "lock in" ticket ID?

2. I also would like to create a workflows as below - When we key in the Part Number (Managed Metadata and we have a excel table saved on the SharePoint), I would like to have the part name and price update itself. However, I try to create my workflow but it just not work, I am not sure which I got wrong.

Hope someone able to help us, as I spend about 2 months now and still can't resolve it. :)

Thank you

Categories:

General topics

Please make sure to separate your questions into different asks. Its the proper way and best way to get actual Answers

Right now you want us to answer multiple things, before you'd accept this as answered, but not everyone could answer both things.

As for your Original Question

You would need to use the IsBlank() expression to check if the current value is Blank, if the current value is blank, then do your Concatenate expression, if not do nothing. Which literally means essentially

If(IsBlank(Blabla), use your expression) the negative will do nothing so you dont need anything and if its NOT blank you also dont want it to change.

We do not even know how they put in their original data, A form? An App? either of those would have easily created the ID for you without the need for the formula

As for the Workflow.

You want to build it out of what? The Business Engine, Flow? Something else?