I have a lookup column in a Sharepoint List. I need the results of this column (Calculated Customer Number) to populate another column (Customer Number) in the same list. I'd love to be able to use a simple formula =[Calculated Customer Number] like you can in Excel, but alas no. My ultimate goal is to use the (Customer Number) column to create a formula that will be used to populate another column (Job Number).
I understand that this can be accomplished through Power Automate, but I have created many attempts to do this and they continually fail. If you have a sample of one that has worked to accomplish this, what should be simple, task or any suggestions, I'll be in your debt!