HR department is having a list to reocrd the information of every employees (now we call this list as "Employee Profile").
On the other hand, HR also requires team leaders to upload the resigination letters to another list as well (we call this list as "Resignation Log").
Once HR see that there is a new resignation letter received, she would find out the Employee ID from "Resignation Log", then change the status at "Employee Profile" base on the Employee ID she found.
And I would like to know that could we create a flow to modify an item in a list once an item created in another list?
Hi,
I am creating a Leave Request Form in PowerApps, added Power Automate flow. Everything working fine.
Now, I need to update my LeaveBalance List (AppliedLeave Column) with the data from Leave List(TotalDays column) once the Leave is approved.
Need your urgent help and advice on this please.
Hi there - I just had this happen. Did you ever figure out how to fix this issue?
Hi,
Please watch
Please like and subscribe this video.I hope it's work for yoh
Why do your need the Filter Array step? Can't you just filter the list right in the Get Items?
Hi Kris,
Your answer is very helpful. However, I have two more required fileds in the sharepoint "Employee Profile"
1. User ID: type of this filed is "Single line of text"
2.Join Date: type of this field is "Date and Time"
Could you please share me more how to write the fomular for this two columns in the step "Update Item" (Under the step "Apply to each"). Becauese this two fileds are required to fill in the setting of "Employee Profile".
Thanks!
HI,
i am trying to recreate an exact table of yours with very similar situations and objectives, the only difference is my employee ID is not a 4 digit number but instead a code (AA123,AB165) and hence the filter array is unable to locate my employee ID. and suggestions of how to solve this so i can lookup the unique employee ID from the parent list
Thanks!
Hello,
I have found this information quite helpful however I am havingone issue. The connecttion seems to be set up and working however it is changing the status of all entries in my second list.
I am creating an acceptance form for students in a program. When a student accepts their seat it should look them up by their Student ID and change their status in my student contact list from perspective to current. However when I test this, it is changing ALL my students on my list to current.
Any thought on what I might be doing wrong or where to look?
x0020 is a space. e.g. the Sharepoint field name would have been "Employee ID", so it becomes
Employee_x0020_ID
If you look at the Sharepoint list via Site Libraries and lists (i.e. open the settings page for tha list), the click on the field as it to edit it, you can see the correct format of the name at the end of the page address.
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2