I get a standard email every morning and I open the attachment and copy the content then paste into another table and sort, filter and dedupe. This would be perfect to automate as the sort, filter, and dedupe can be done through the query connection in the Excel table.
However I am running into a slight issue with my flow. I have it triggered when that specific email arrives and I want to grab the content and add it into a table. However if I use update file then my history is gone and I need to keep the history (hence I sort and filter to keep most current on top (i.e descending order on date).
How do I dynamically add these rows when I am not presented with the dynamic information?
Solved! Go to Solution.
Hi @Anonymous ,
Do you mean to add the records in the Excel table contained in the attachment to the specified table?
It seems that this is difficult to achieve because we first need to get the data in the Attchment and need to be able to traverse them.
But when we configure List rows present in a table action, generally we can only configure the saved Excel file.
In your existing configuration, the file has not yet been created. The file will be generated when Flow finishes running, so we cannot use it when configuring Flow. There is also no suitable way to parse out Dynamic content for use.
Please check online doc and get more details about Excel online connector:
https://docs.microsoft.com/en-gb/connectors/excelonlinebusiness/#known-issues-and-limitations
Best Regards,
Hi @Anonymous
Could you please explain what you meant by history is gone?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @Anonymous Maeby you could do this.
When you insert the rows into a table then you can wait some period of time like 10s to read again the content. Then If you want to filter someting you can use Filter Array and this can allow you to compare a colum and if exist the output wil be only the rows that are the same to the value compared, after that you can add rows in other excel table if you want.
Proud to be a Flownaut!
Hi @Anonymous ,
Do you mean to add the records in the Excel table contained in the attachment to the specified table?
It seems that this is difficult to achieve because we first need to get the data in the Attchment and need to be able to traverse them.
But when we configure List rows present in a table action, generally we can only configure the saved Excel file.
In your existing configuration, the file has not yet been created. The file will be generated when Flow finishes running, so we cannot use it when configuring Flow. There is also no suitable way to parse out Dynamic content for use.
Please check online doc and get more details about Excel online connector:
https://docs.microsoft.com/en-gb/connectors/excelonlinebusiness/#known-issues-and-limitations
Best Regards,
Thank you. I figured it had something to do with that. I will do two flows and trigger the second one on the creation of the file.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
70 | |
22 | |
17 | |
17 | |
13 |
User | Count |
---|---|
125 | |
34 | |
31 | |
28 | |
26 |