Power Platform Community Forum Thread Details

In PowerApps, I have a gallery named "taskList" that is utilizing the "TB_FORM" in the "items" property to fetch and display data. This gallery includes a "Title3" and a checkbox named "task". My goal is for the text to be struck through when the checkbox is selected. To achieve this, I used the "task.value" code in the "strikethrough" property of "Title3".

My idea is that once the text is strikethrough, it should be moved to the bottom of the gallery(for each user who checked the box in each task maybe we should do this on powerapps) In my SharePoint list, the data displayed as "title" and "url" are come from "TB_FORM". However, the users and the "CheckboxStatus", TaskID column are located in the "UserGroupStatus" list. i don't know a effective way of do this because there are to many task to a sigle user divided by group as you can see in my filter app in the structure bellow and it will take to much time to add multiples row of tasks for single user in my database because there are more than 200 of users

My idea too is to move the task ID from TB_FORM to the colum TaskID in userGroupStatus to count how many users have checked the box the idea is when someoneone check the box of a specificly task from TB_FORM move the id to the TaskID wich is a multiple lines of text field in sharepoint list and i believie this solve the problem above, and too will be usefull

Another problem that is ocorring is that when i hit the checkbox and then refresh the page the check is unchecked

Here's how my gallery item fields are structured:

App OnStart:

ClearCollect(
 colUserGroupStatus,
 AddColumns(
 UserGroupStatus,
 "UserEmailStr", UserEmail.Email,
 "GroupStr", GroupStatus.Value,
 "IDUserGroupStatus", ID
 )
);

taskList Gallery items:

//(Gallery) taskList = Items

Filter(
 TB_FORM,
 DueDate > Today(),
 true in ForAll(
 LookUp(
 UserGroupStatus,
 UserEmail.Email = User().Email
 ).GroupStatus.Value,
 ThisRecord in Group.Value
 )
)

Title 3 inside the gallery:

//Title 3 inside the gallery taskList

Text = ThisItem.Title


//Title 3 inside the gallery taskList
Strikethrough = task.Value

Checkbox task(name) inside the gallery:

Checkbox task onCheck = true

Checkbox task onUncheck = false

In my SharePoint lists, the fields are as follows:

TB_FORM List:

ID: Number, a unique identifier for the task.
Title: Text, the title of the task.
DueDate: Date, the due date of the task.
Modified: Date, the date when the task was last modified.
Created: Date, the date when the task was created.
Created By: User, the user who created the task.
Modified By: User, the user who last modified the task.
Group: Choice, the group to which the task is assigned.
formUrl: Hyperlink, the URL of the form associated with the task.

UserGroupStatus List:

ID: Number, a unique identifier for the record.
UserEmail: User, the email of the user.
GroupStatus: Choice, the group to which the user belongs.
CheckboxStatus: Yes/No (Boolean), the status of the checkbox. (i don't know if it can be used because in list usergroupstatus only have one checkbox to each user but in the list tb_form are a lot of tasks for only one user and when it be checked it will check all the other tasks)
DataConclusao: Date, the completion date of the task.
TaskID: multiple lines of text