Unanswered

Create New View using Power Automate

(0) Share

Report

Posted on by Hardhat

I would like to create a new list view and make it default when a new date is entered on the list. I have been able to create the new view and make it default, the issue I am having is that it makes a new view every time there is a change or new item created. The list is a daily report that the leaders look at. They want to store and be able to compare past data. All of the articles I have found on this have two list with a lookup it possible to do with just on list?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Hardhat

Why are you creating the view in your Flow? Why not simply create the view manually as it only needs to be created once?

Was this reply helpful? Yes No
Hardhat 2 on at

Like (0)

Report

The list is fed by a from that multiple teams fill out. The goal here is to automate the creation of the view so that no one has to go in and create it for the leaders that will be reviewing the daily data. Current process it all the teams send there information to one person who then enters all the data into a spreadsheet and the emails it out the daily report. Then sends a second email to teams that only need a portion of the information. Once I have the view creation set up I can the set up an automate email to send out only the information needed from the default view. End goal, have one from for the teams to fill out one location for all date current and historical. One click for the leaders to review the daily data and automate the emails that go out. No one would have to touch it once the form is filled out.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Hardhat

To the best of my knowledge you'll need to make an HTTP call and retrieve the list schema. All existing views are included in the schema, so you'll need to check for the existence of a view before creating that view. A lot of work...

You may want to consider simply using a single Grouped view with a grouping for each of the teams. Another option might be to set permissions on the list items such that only the group that needs to review the data can see those list entries (not the best idea...).

Was this reply helpful? Yes No