I've been stuck with my flow for a bit, as I can't get this one step in my flow to work.
I want my flow to work when my Outlook inbox receives an automated email with an attachment that also includes the same table of data in its body text. I want it to then Compose an Email that Extracts from a Cell in Table based off of when the last number in Column "% Forecast Committed" is less than 100%.
The part I've been stuck on is that it doesn't seem to be reading the last cell as an integer even when I've set up actions to separate the %. Would really appreciate the help!
I understand that you're trying to convert the “% Forecast Committed” value into an integer. To achieve this, you can use the following Power FX expression in Power Automate: int(replace(outputs('Html_to_text')?['body'], '%', '')) This expression performs the following steps:
Retrieves the output of the Html to text action.
Removes the % symbol using the replace() function.
Converts the resulting string to an integer using the int() function.
By using this you will get value in the Integer format.
Hope this helps.
Thanks!
Inogic
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
4
Share
Report
All responses (
Answers (
