Hi @Anonymous,
Currently, we could not get excel table data from the excel attachment of an email directly in Microsoft Flow. You could consider take a try to save the Excel attachment to a OneDrive folder firstly, then get excel table data from the Excel file saved in your OneDrive folder.
I have made a test on my side and please take a try with the following workaround:
- Add a Recurrence trigger, Interval set to 1 and Frequency set to Day, At these hours field set to 3.
- Add a "Get emails" action, Include Attachments field set to Yes, Top field set to 1.
- Add a "Apply to each" action, input parameter set to output of "Get emails" action.
- Within "Apply to each" action, Add a "Apply to each 2" action, input parameter set to following formula:
item()?['Attachments']
- Within "Apply to each 2" action, add a Condition, click "Edit in advanced mode", type the following formula:
@contains(items('Apply_to_each_2')?['Name'], '.xlsx')
Within "If/yes" branch of Condition, add a "Create file" action of OneDrive connector, specify Folder Path, File Name field set to Name dynamic content of "Get emails" action, File Content field set to Content dynamic content of "Get emails" action.
Add a "Get rows" action, File name field set to Id dynamic content of "Create file" action, Table name set to custom value Table1.
Add a "Apply to each 3" action, input parameter set to output of "Get rows" action. Within "Apply to each 3" action, add a "Create item" action of SharePoint connector, specify Site Address and List Name. Title field set to following formula:
item()?['__PowerAppsId__']
TaskName field set to following formula:
item()?['TaskName']
Executor field set to following formula:
item()?['Executor']
Due Date field set to following formula:
item()?['Due_x0020_Date']
Note: TaskName, Executor and Due Date column are columns in my Excel table, you could use following formula to get the column value within your Excel table:
item()?['ColumnName']
If there is a space within column name, please use '_x0020_' instead of the space within above formula.
Image reference:
The flow works successfully as below:
More details about using expression in flow actions, please check the following article:
https://flow.microsoft.com/en-us/blog/use-expressions-in-actions/
Best regards,
Kris
