Hi everyone,
TL;DR: How do I format SharePoint Lists created through HTTP Request during a flow?
My goal is to create a new SharePoint List with advanced view formatting with a Flow in Power Automate.
I might be over-complicating what I want to do, but here is the context:
This is a flow that triggers when an item is added to my SharePoint List and creates another List and links back to it.
I got that part done using HTTP requests.
Here is my current flow.
This is the body of the HTTP request:
The next part would be to format the new SharePoint List view to include a new button in the command bar that, when clicked triggers another Flow that will allow me to add multiple copies of the same record when specified. For example:
The new button would prompt to a formatted record entry form that would ask for the following fields:
Input
Number of vials: 3
Reagent: Cell Culture Media
Location: Lab1
Expiration: 04/20/2023
Output
Item Name, Location, Expiration
Cell Culture Media, Lab1, 04/20/2023
Cell Culture Media, Lab1, 04/20/2023
Cell Culture Media, Lab1, 04/20/2023
This entry will add 3 items (ie. 3 rows) to the new SharePoint List. All with the same data (different autogenerated IDs of course).
The main problem for me is that I want to do this by formatting the view and/or column at the moment of making the new SharePoint List, modifying this section:
Is this possible?
Some workarounds I've thought of are:
1. Create a base template myself for the new SharePoint List in the folder where they will be created, then make the first flow just copy that template list with a new name whenever a new item is added to the master List.
2. Make the 2nd Flow trigger automatically when a new item is added to any SharePoint List in the folder where the new Lists will be saved, forgetting about formatting and adding the new button to the new SharePoint List dynamically.
Thank you!