Closer looks at the flows from the post, Automate daily notifications and weekly report from a single Excel email attachment (Case Study 1)
Flow 1: Save an Excel file email attachment to a SharePoint folder, and add an Excel table to that file.
Flow 2: Add each row of the new Excel table to a SharePoint list.
Something very strange happens in this Apply to each box. You would expect that you could choose the Excel dynamic content fields, but they do not appear. You have to create them as Expressions instead. The first time you create this flow they will all show up as pink expression boxes, but once you save, close, and reopen they will display as the green Excel dynamic buttons you wanted in the first place.
Copy the column headers as they appear in the Excel documents, without spaces. These headers have no spaces but they do have underscores between words. Keep underscores in your expression.
Expression for the column ISBN: items('Apply_to_each')?['ISBN']
Weekly Report and Email to Distribution List
Comments
Post a Comment