Unanswered

Help with flow design: certian SharePoint list components to premade excel file template

(0) Share

Report

Posted on by powersteveomate

Hello,

I'm seeking suggestions to best go about this. I currently have a python script that parses a json file and places particular items into an excel template (placing the items in particular cells) and outputting a new file.

Is it possible to use Power Automate to go into a SharePoint list, grab particular column items (one list item at a time) and place those items into an excel template (in particular cells) and then save that as a new file?

Any thoughts on this would be greatly appreciated!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

srduval 1,760 Moderator on at

Like (0)

Report

by default the behavior would be one row at a time, the excel file has to be formatted as a table, then you can add rows to the table. by mapping dynamic values to the row headers. If you are wanting to get value 1 from list 1 and put it in cell d22 of an excel sheet, I don't think it will work. However if the excel file is laid in a way that D21 could be a table header and d22 be the row, you could probably make it work.

Was this reply helpful? Yes No
powersteveomate 2 on at

Like (0)

Report

Thanks for the reply! Given that I can't really use a template the way that I was intending, do you know of a way to fully incorporate a python script (including libraries and such) to do this?

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (0)

Report

Looks like it's possible in power automate desktop, not sure about the cloud. But depending on what exactly you're needing to do, if you're needing it automated, you can have a cloud flow "listen" for the event trigger, then when the event triggers run the desktop flow, but that's not a universal thing for multiple users (except if you buy an unattended license I think you might be able to pull it off), as you have to specify a gateway, which has to be on the machine that will run the desktop flow.
Scripting - Power Automate | Microsoft Docs

Was this reply helpful? Yes No