Share
Report
81Hi
What I'm trying to achieve is to let the user specify a bunch of inputs that point to an excel-file somewhere on oneDrive, grab the rows and create Planner Tasks from them for a user-specified group/plan/bucket.
I have managed to work out all of the dynamic stuff with regards to getting the file from oneDrive and with regards to creating Planner Tasks and the associated ID-salad.
However, I am stuck at grabbing the content from the excel-file, because none of the table's columns are listed under the options for 'add dynamic content', due to the editor not resolving files/tables that are only specified via dynamic values. E.g. in the screenshot below I would like to for each row in the specified file/table use their respective value from a specific column to enter as Planner titles.
It is worth noting, that there is a policy/template in place for all the different excel-files, so all the tables and their columns are well defined and have the same names/column-names.
So my question is, can I somehow still get a hold of those table-headers or is this a lost cause? Or I guess more precisely, how do the normally available dynamic content "items" actually work?
I assume I can somehow specify that I want to get content from the 'List rows present in a table'-action and then, because all of the tables in the different files are identical in terms of structure, specify which of its "items"/columns I want, but I am not familiar with how to do that.
Any help, ideas or resources are very welcome.
Best regards,
JP
All responses (
Answers (
