hi everyone,
any help you can extend to me will be great! 🙂
I have this little project where I need to patch all selected items, but somehow, I only works for the 1st record even though I selected several items.
I followed the video by @Shanescows https://www.youtube.com/watch?v=0xZ4fMJbLvk&t=1387s and yet, I got no success. the difference is that I want to filter out my collection before using it in the ForAll function. Thank you in advance, below are the scripts I have so far.
I have a button to create the Collection:
ClearCollect(
DataCollection,
AddColumns(
Approval_Workflow_Invoice,
"IsChosen", false,
"WhoIsApprover", "fname.sname@mail.com" //Office365Users.MyProfileV2().mail
)
)
and in my 'Patch Selected' button:
Solved! Go to Solution.
thanks @PowerAddict for taking the time to help me on this. I finally made this worked, I should have just stick with the video of @Shanescows from the start. I thought I have to replace the lookup item to something else instead of using ID = EID, when I finally tried using that, it worked like a charm! 🙂
the solution is this video by @Shanescows
Select multiple records in a gallery and Patch with the PowerApps ForAll function
Hi @PowerAddict, thank you for looking at this. yes, if you don't mind, it will be very helpful for me if you can write this based on my sample data, I'm kinda new to this one. 🙂
thanks again.
let me explain what I am trying to achieve.
I have a sharepoint list, in this list I have records with Assigned Approver (AA) and if the AA is going for a vacation he/she will assign a delegate to work on his/her active tasks, Delegate Approver (DA)
Task AA DA
task1 a1
task2 a1
task3 a2
task4 a1
task5 a3
now I like to have a PowerApps screen where, when AA accesses this screen, he/she will see a list of his/her tasks ONLY (a gallery). S/He can either select individual tasks or all the tasks and by clicking button, the DA will be set to whomever s/he chose from a DA dropdown box, something like below should happen.
assign a delegate to work on his/her active tasks, Delegate Approver (DA)
Task AA DA
task1 a1 a2
task2 a1 a2
task3 a2
task4 a1 a3
task5 a3
hopefully this one is clearer. thanks again @PowerAddict 🙂
thanks @PowerAddict for taking the time to help me on this. I finally made this worked, I should have just stick with the video of @Shanescows from the start. I thought I have to replace the lookup item to something else instead of using ID = EID, when I finally tried using that, it worked like a charm! 🙂
the solution is this video by @Shanescows
Select multiple records in a gallery and Patch with the PowerApps ForAll function
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
205 | |
187 | |
77 | |
48 | |
37 |
User | Count |
---|---|
321 | |
262 | |
124 | |
73 | |
58 |