cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ShaikSayyad
Level: Powered On

retrieve and update items from one list and save those to another list and update in a CheckList way(Gallery)

Hi Mates,

I have ListA, ListB( ListB has additional Status field for-CheckBox) with same fields , ListA has records.

Here I want to retrieve ListA items(Selectd Dropdown) to ListB as the new checklist form.

CheckList form should have save and edit options.

CheckList.png

I want check list form Like the above, please help me.

 

Thank you.

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: retrieve and update items from one list and save those to another list and update in a CheckList way(Gallery)

Hi @ShaikSayyad ,

Do you want to choose items of listA as new records of listB by using a check boxes?

Firstly, you need to set the gallery's items based on the selection of the drop down.

For example: 

Filter(listA,fieldname=drop down1.Selected.Value)  

Secondly, set the submit  button's OnSelect:

Collect(lisrB,Filter(Gallery1.AllItems,checkbox.Value=true))   //update listB with the selected items inside the gallery

If Gallery1.AllItems have some fields that you do not need to update, you could use ShowColumns functin.

If Gallery1.AllItems have some different fieldnames with listB, you could use RenameColumns functin.

For example:

Collect(lisrB,RenameColumns(ShowColumns(Filter(Gallery1.AllItems,checkbox.Value=true),"fieldname1","fieldname2"),"fieldname1","fieldname3")) 

 

Best regards,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ShaikSayyad
Level: Powered On

Re: retrieve and update items from one list and save those to another list and update in a CheckList way(Gallery)

Thank you for response.

Let me clarify you here ListB is task status tracking list, so I can filter the items(Those have to record into ListB) from ListA by Dropdown selection. I need to insert checkBox to save the option (ListB Choice Field called LibraryCompleted with options "Yes", "No") in the gallery.

If I had check on checkBox, ListB LibraryCompleted field should be saved as Yes else No.

ListA Fileds: ID_1, ID_2, ID_3, and some another fields

ListB Fileds: ID_1, ID_2, ID_3, and LibraryCompleted (CheckBox in the Gallery).

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 247 members 5,625 guests
Recent signins:
Please welcome our newest community members: