Hi all,
I am using an automated flow to extract data from an email into excel sheet. The flow works fine, my variables are filled with the right data, but when I’m trying to use the variables to fill the column in excel it’s not working. It returns me an error code 409. I don’t know what’s wrong.
I tried also to let power automate create the tables and this works. But im not able to add data to the column.
My flow is as follows:
- when an email arrives
- HTML to text
- Compose email body text (with the outpost of html to text)
- Compose (split function)
- Initialize all my variables as string
- Compose to extract data for each variable (trim(substring(split(outputs(‘ExtractData’), ‘: ‘)[1], ‘Number’)))
- Set variable (filled with the output)
- Add a row into a table (and this is were I get the error message)
Do you guys have any suggestions?
