I'm trying to create a flow that will add a row to a table of an Excel file stored in Sharepoint, most of which I've figured out, but I also need to use some of the Subject and add this to a column within the Excel table.
The table looks like this;
I want to be able to take the name in brackets at the end of the Subject and add this to the User column. The wording in the Subject will always be one of the two Subjects that you see here. I was hoping I could add an expression to "add a row" in the flow that would do this but I don't know how and am having trouble finding a way to do it. The flow is shown below;
Any help gratefully received!
Solved! Go to Solution.