You’re offline. This is a read only version of the page.
81
Hi
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
Just in case anyone has a similar problem. It's simply a matter of looking at the JSON-response returned in the 'List rows present in a table'-action and extracting the right attributes by writing an expression.
In my case
Share
Report
All responses (
Answers (
body('List_rows_present_in_a_table')?['value'] for the value in the 'Apply to each' action and
items('Apply_to_each')?['TaskTitle']to get the desired column in the 'Create a Task'-action.
After running it once, the flow then realises what the custom expression stands for and creates a matching icon. However, renaming any of the involved actions apparently does not update the custom expressions yet the icons still remain, so be mindful of that.
