filter my pending approval tasks

(0) Share

Report

Posted on by octaking

320

I am using the following formula

Status = 'Status (approval requests)'. Active

but this gives me back all the history of approvals that have already been approved or rejected and even pending

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

PavanKumar 479 on at

Like (0)

Report
Copy link

Link copied!

Hi, You seems to be using wrong Status field in the filter. Status with Values Active and Inactive is default OOB status field. it will not have any values like approved, Rejected, Pending Etc. If you could double check the correct status field which you need to use that may help. If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Regards, Pavan Kumar Garlapati

Was this reply helpful? Yes No
octaking 320 on at

Like (0)

Report
Copy link

Link copied!

Hi @PavanKumar
Thanks for answering
So what field should I use?

Was this reply helpful? Yes No
PavanKumar 479 on at

Like (0)

Report
Copy link

Link copied!

Hi @octaking,

Whatever is the name of the status field which has APPROVED,PENDING ETC. Use that field for filtering.

Please mark it as verified if it answers your question.
Regards,
Pavan Kumar Garlapati

Was this reply helpful? Yes No
octaking 320 on at

Like (0)

Report
Copy link

Link copied!

Hi @PavanKumar
In no approval request field are the values of APPROVE REJECT OR PENDING, the only field that has those values is Result but is in a data source called Approvals

Was this reply helpful? Yes No
PavanKumar 479 on at

Like (0)

Report
Copy link

Link copied!

Hi,

No Problem. Let me elaborate that may help you.

From approval requests table you want to display list of approval requests with certain status only not all status records e.g you want to display list of my approval requests with approval status as pending.

From Approval Requests table how can you be able to figure out whether the record is pending or approved etc? there should be a field which shows that isn't it?

We should use that field in the formulae to display all approval requests with approval status (lets say your field name is this) = pending.

If this answers your question please mark it as verified.
Regards,
Pavan Kumar Garlapati

Was this reply helpful? Yes No
octaking 320 on at

Like (0)

Report
Copy link

Link copied!

Hi @PavanKumar

There is no approval request field that is equal to Rejection pending, etc.
Look at a filter that I have in another gallery

SortByColumns (Filter (AddColumns (Approvals, "OwnerEmail", AsType (Owner, Users). 'Primary Email'), Status = 'Status (Approvals)'. '0', OwnerEmail = User (). Email),
"createdon", descending)

this if I filter the requests I made that are pending
since this comes from a source called (Approvals)
and this source if it has fields like
Result which has the values Approve, Reject

but I have another gallery of approvals that I received from the source (Request for approvals)
where I want to filter the approvals that I have received and that are pending, but this source does not have a field by which I can make a filter
it can be with a search function since the values that I want are at the source of approvals

Was this reply helpful? Yes No
PavanKumar 479 on at

Like (0)

Report
Copy link

Link copied!

May I see your approvals entity/table columns. Regards, Pavan Kumar Garlapati

Was this reply helpful? Yes No