Approval based on Gallery Selected

(0) Share

Report

Posted on by Am4ree

Hello Community,

Seek your advise and help for below case that I struggle within.

So, I have 2 Data Sources (SharePoint) as shown below

1. ascis pr tracking

2. item list

Gallery1_2 with ascis pr tacking and filtered only show up state "Submitted".

Gallery 5_2 with item list.

Currently wherever Icon > clicked on gallery 1_2, Item list will show up based on Gallery1_2 selected.

Goals.

I put 2 Icons on the top of the corner, Icon_Approve and Icon_Reject.

I want to achieved approval based on Gallery 1_2 Selected and patch column state in ascis pr tracking from "submitted" to "approved by manager" as I have defined choices on the sharepoint list. Once state changed to "Approved by Manager", the list selected automatically disappears from Gallery1_2.

Same also with Icon_Reject, once icon_reject clicked, the state will change to "Rejected by Manager" and the list selected will disappear on Gallery1_2

Appreciated if anyone can advise me with this case.

Thank You.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

AJ_vizMan on at

Like (0)

Report
Copy link

Link copied!

Hi @Am4ree - Please refer this thread where lookup column is not recommended to use (Depends on use of solution and other factors)
Solved: How to update a lookup field in SharePoint List - Power Platform Community (microsoft.com)

One way to achieve is by using Power Automate -
take a look here Update SharePoint column only if there's a value using Power Automate (tomriha.com)

You can use trigger ' When an item is created or Updated' in SharePoint list1 and than use the conditions accordingly to update value in List 2

Let me know if, i can further help you on this

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @Am4ree ,

Your said your first gallery is filtered on "State = Submitted".

If you change the value of "State" to "Approved" or "Rejected", it will no longer be equal to "Submitted" which explains why the record isn't displayed anymore in your gallery.

Was this reply helpful? Yes No
Am4ree 40 on at

Like (0)

Report
Copy link

Link copied!

Hi @AJ_vizMan ,

I just only need update one record on SP list 1 "ascis pr tracking". state column is one of column from "ascis pr tracking". I thought that is possible with defined variable and patch it to SP, However Thank you and let me try your advise with automate,

Was this reply helpful? Yes No
Am4ree 40 on at

Like (0)

Report
Copy link

Link copied!

Hi @WiZey ,

Yes Correct, Gallery1_2 (First Gallery) filtered only "State = Submitted".
And it should be disappear after State changed " Approved" or 'Rejected'.
but I still struggle to update the "state = submitted" to "approved" based on gallery1_2 (First Gallery) selected.

Was this reply helpful? Yes No
Verified answer

WiZey 3,023 Moderator on at

Like (0)

Report
Copy link

Link copied!
If you want to update a record in a SharePoint list, you can use either "Patch()", "Update()" or "UpdateIf()".

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-patch
https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-update-updateif

With "Patch()" it would be something like this (note that "Update()" follow the same pattern):

Patch( source, Gallery.Selected, {value: {Value:newValue}} )

With "UpdateIf()" it should look like this:

UpdateIf( source, ID = Gallery.Selected.ID, {value: {Value:newValue}} )

Hope this was helpful to you.

Was this reply helpful? Yes No
Am4ree 40 on at

Like (0)

Report
Copy link

Link copied!

Hi @WiZey

Thank you & let me try your advise.

Hopefully it will work.

Was this reply helpful? Yes No