Power Platform Community Forum Thread Details

Hi All, I receive UCR details from the BOT in a shared mailbox after each shipment. The BOT-generated email contains a table with one or more UCR numbers. I have already created a Power Automate flow that automatically forwards these BOT-generated emails to the respective carriers. The next requirement is to enhance the flow so that it:

1. Extracts only the UCR number(s) from the email content.

2. Updates the extracted UCR number(s) into the Excel file under the "UCR Number" column.

3. Automatically populates the "UCR Sent" column with the date and time when the email is sent to the carrier.

4. Supports scenarios where a single email contains multiple UCR numbers within the table and ensures that all UCRs are captured and recorded correctly.

A sample UCR Table has been attached for reference.

Advise the best approach to implement this in Power Automate please.