nemail a gallery list & remove item from gallery once done

(0) Share

Report

Posted on by AliciaDG

Hi, I have an app i am currently building.

What i am trying to do i want to pull the answer to a question asked

create a checkbox once the checkbox is marked send all checkbox items off in an email.

the second thing i want to be able to do is once they have been checked off i want the items to dissapear on the gallery but stay in the sharepoint list?

is that possible

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AliciaDG,

Could you please share more detail on your scenario? What is the Items property of Gallery?

I made a test demo for your case, hope this helps.

Add a new column "Selected?" to the data source of Gallery to store the selection of check box for each items

ClearCollect(myCol,AddColumns('SP list',"Selected?",false)) //App.OnStart or Screen.OnVisible.

Set Gallery.Items property as follows to filter out these checked items.

Filter(myCol,!'Selected?')

Configure Main check box as follows to control all sub check boxes.

UpdateIf(myCol,true,{'Selected?':false}) //OnUncheck property
UpdateIf(myCol,ID in GalleryName.AllItems.ID,{'Selected?':true})//OnCheck property

Configure sub check box as follows.

ThisItem.'Selected?' //Default property
Patch(myCol,ThisItem,{'Selected?':true})//OnCheck property
Patch(col2,ThisItem,{'Selected?':false})//OnUncheck property

Sik

Was this reply helpful? Yes No
AliciaDG 93 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft ,

Thanks for the info!

i am still fairly new this and am having trouble with one of the steps.

For the Set.Gallery.items property i already have a sortby columns filter so i can search info based on the request. how do i add the additional filter function required. below is the function that is currently in there.

Ideally is there a way to have the filter function sort by title / date submitted as well including the selected function?

SortByColumns(Filter([@'sharepoint list name'], StartsWith(Title, TextSearchBox1.Text)), "Title",
If(SortDescending1, Descending, Ascending))

the other thing that isnt working is the sub check box formula for the OnUncheck formula

Error below

Finally would you know how to set it up so that if i click the checked button it will email me the data that is being hidden?

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AliciaDG ,

First, put the following code to App.OnStart, then use myCol into the Filter code in Gallery.Items.

ClearCollect(myCol,AddColumns('SP list',"Selected?",false)) //App.OnStart or Screen.OnVisible.
SortByColumns(Filter(myCol, StartsWith(Title, TextSearchBox1.Text) && !'Selected?'), "Title", If(SortDescending1, Descending, Ascending)) // Gallery.Items

In Check2.OnUncheck property, the data source of patch formula should also be myCol (I mistyped col2 ), please try this:

Patch(myCol,ThisItem,{'Selected?':false})//OnUncheck property

Hope this helps.

Sik

Was this reply helpful? Yes No
AliciaDG 93 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft ,

The ALL Check button works removes all the data. however and i don't know what i am doing. When i check the data from the box itself it doesn't clear it. It takes it to the detail page. where it shows me all the data.

The other thing that has also now happened the details page and the edit page isnt pulling the data from the gallery items

for the details page following error

for the edit form

Was this reply helpful? Yes No
AliciaDG 93 on at

Like
a
(0)

Report
Copy link

Link copied!

Is anyone able to assist me with the above question?

Was this reply helpful? Yes No