How to check the status of the previous item in a gallery?

(0) Share

Report

Posted on by EdouardVH

Hello everyone.

I have a task management app and would like your help.

The objective of this application is that the user selects a building and sees its tasks to be carried out.

I thus created several sharepoint lists according to a task and in this list I informed the building and the user concerned by the task.

The names of the lists and the names of the tasks are the same.

I thus created a gallery which displays all the tasks of the user, when he selects the task he is redirected to another page in which he can validate the task.

I would like to prevent the user from being able to select and validate a task when the previous one is not done.

do you have any idea how i could solve this problem?

thanks

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

MF-12051538-0 406 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @EdouardVH ,

If you could add an index column for the steps in your SP lists, then you could LookUp the highest index value for your list where 'completed' = true, and then only allow navigation for those records where the index is no more than 1 greater than the number you look up.

I hope this helps.
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @EdouardVH :

Are the tasks in your task list arranged in order? If so the previous task of the task selected by the user can be found by ID.

For Example:

LookUp( Sort(YourSPList,ID,Descending), ID<YourGallery.Selected.ID ).Status

Best Regards,

Bof
EdouardVH 50 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help,