So I have an excel file with two sheets, each sheet has a table on it.
I am using the get file content component to pull the content of this file to create an array of attachments.
The first sheet of the file attached to the email is perfect, but the second sheet only contains one row, when the original file contains at least thirty on that sheet.
Does anyone know how to fix this?
Solved! Go to Solution.
You could try the Get Tables action for Excel which will give you an array of the tables in the workbook with which you could do an Apply To Teach and then List Rows from each table, etc.
Regards,
Pat
To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.
You could try the Get Tables action for Excel which will give you an array of the tables in the workbook with which you could do an Apply To Teach and then List Rows from each table, etc.
Regards,
Pat
To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.
How would that work with respect to creating the attachment array though?
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 |
---|---|
66 | |
23 | |
16 | |
16 | |
13 |
User | Count |
---|---|
116 | |
35 | |
32 | |
28 | |
26 |