Good morning Power Automate gurus!
I'm trying to build my first flow and could use some assistance.
I need to extract some content between two delimiters of an Email Subject. I have taken some guidance from here (https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-split) where the article talks about Substring Extraction.
In my case, the Email Subject is: "Refresh failed: Your Dataflow Name ABC123 dataflow couldn’t be refreshed"
Starting delimiter is: "Refresh failed: Your "
Ending delimited is: " dataflow couldn’t be refreshed"
Text to extract is "Dataflow Name ABC123" (which changes depending upon what has failed.
In Power Automated, I'm using "SharePoint Create Item" and trying to use the following string to log what has failed, but I get an error saying "Expression is invalid".
First( Split( Last( Split( "triggerOutputs()?['body/subject']", "Refresh failed: Your Open " ) ).Result, " dataflow couldn’t be refreshed" ) ).Result
Can anyone please suggest that I need to do to fix this?
