How do I create a new list that is filled based on attributes selected in PowerApps?

[bh21]

Hi all,

I haven't been able to find any resources to help me with my current query.

Essentially, I currently have one list (List 1) which is two columns, with entity names and TRUE or FALSE. This list will be regularly updated to reflect whether or not these entities are required to report (true/false).

What I am wanting, is a function in my PowerApp that allows a new list to be created and somewhat filled based on the values of List 1. So for example, in PowerApps a user might see a checklist of all the entities that are True in List 1, a text area to type in the year, and they click a "Create list" button and it will create a Sharepoint List that is prefilled with those entities for that year's reporting. 

(I have added a graphic of what I want to happen).

The new list also would need many more columns as there are multiple reporting requirements which the selected entity will need to meet.

At the moment, my PowerApp just allows me to edit/add entries to List 1 which is how we will maintain that list. I would like it all in one app.

Any help is appreciated.

Thank you.

[v-xiaochen-msft · Accepted solution]

Hi @bh21 ,

I did a demo for you.

Note: New list created by flow only has a default column 'Title'. If you need more columns, please modify this flow as your needs.

Filter(LIST210,Col2=true)

Test302.Run(JSON(ShowColumns(Gallery1.AllItems,"Title"),JSONFormat.Compact),TextInput1.Text)

_api/web/lists/

{
"BaseTemplate": 100,
"Title": "@{variables('var2')} List 2"
}

json(variables('var1'))

_api/web/lists/GetByTitle('@{variables('var2')} List 2')/items/

{
"Title":"@{items('Apply_to_each')['Title']}"
}

Finally, make sure the user using the api has permission to create list/items.

Best Regards,

Wearsky