Unanswered

Quotation approval

(0) Share

Report

Posted on by ChristinaT05

I have a screen where admin will have a list of quotations to ship items from one location to the other. For a particular request ID, only one request can be approved. (Eg. for request ID 23, only one quotation will be approved while the rest will be rejected.) I have a filter available on the screen which will display only the entered request ID.

What I want to do is, on the view quotation screen, the admin will search for a request ID and all relevant quotations for that request ID will be displayed. Out of those displayed quotations, admin clicks on the approve button for one quotation and the button changes to approved, the rest get disabled/button changes to rejected.

How can I achieve this?

Categories:

Building Power Apps

Screenshot (195).png

I have the same question (0)

All responses (2)

Answers (0)

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report
Hi @ChristinaT05

Consider the following:

Your quotation has a status column, if not I suggest you add one.

When your related quotations are called, they will have the default status (I'll use "active")

add the collection to a gallery like you have done

Use UpdateIf to update all the relevant quotations which is not the selected quotation (ThisItem ) as "rejected"

Use Patch to update the selected quotation as "approved"

Set the Display mode of the approval button in line with the status.

Example

Was this reply helpful? Yes No
ChristinaT05 2 on at

Like (0)

Report

I am not able to see which formula is applied where due to a limited portion of the screen being shown (the left pane has been cropped out). Would it be possible for you to send screenshots or type in where which formula is being so I have the complete picture?

Was this reply helpful? Yes No