Update a secondary SharePoint list using Flow

Hi Daniel,

Awesome video, I am looking for something similar... I am working on a parent and child list for inventory management. Where items get status reserved when selected within the parent list. Are you able to assist me with a flow for this?

Thankyou - how might I turn a Yes/No filed from Yes to a No? Ie I Create an item and it does a lookup to see that there is another item with the same value and turns the value to No

Hi Daniel
Thank You for your video, I want to use your tutorial to create simple data warehouse. so I create 2list datawarehouse with column inventoryID,InventoryName,TotalQty,CurrentQty and operationalUse with column InventoryName and QtyUse.
can you help me, how to subtract with QtyUse column with your command ?
"@sub(item())?['TotalQty'],- ???

Many Thanks
Adi

Good Session @daniel ! i have a query in my share point list had a column name "add" if any one editing the item in that list the value in "add" column has to add with existing value eg: the previous value in "add" column is 10 i want to edit and entered value 20 i want my output with adding 10+20+30 is that possible in share point list??

Hi
How would you delete an item from the parent and have the child update?

I have column name "comment"...How to import string to that column using compose?

Thank you, just needed a small part of that but got my flow working, cheers

Thank you, Daniel, very helpful! I need to do something similar but with attachments. getting an attachments from a secondary list and updating the primary list. Seems like attachments follow a different logic. Do you have any information regarding this?

How to apply for Task list ?

Hi, i wanted to do a similar workflow, but rather than subtracting 1 i want to subtract the value from another column? "@sub(item()?['DaysUsed'],DaysTook)" sot of thing? How would this be done? I tried just using a field instead of the 1, but it didn't like it Thanks

hi i am adding 20-30 rows at a time in parent list, and in child list i am using the count of rows. but since data is added very fast, count in all the new fields in child list is appearing same. i used delay also, but same thing is happening.

Hello this is very nice tutorial,
Can you please help me to pass dynamic value on the > sub(item()?['SickLeaBal'],5)< Here 5 must be replaced by parent column called LeaveUtilization.

Hello Daniel nice video, thanks a lot.
But please, in the compose box, how do i subtract the value of a field that was added as part of the created an item part from the value of a field that is in the get item list?

what if in the parent list i have a quantity column where in I can input number of keyboards instead of creating item 1 by 1 item? How would be the computing expression in Flow to get the total of keyboards based on the quantity columns?

This is great! Does Flow stop searching after it hits 100 items? I have a list of 1035 I figured that could be the issue.

Is this Flow running for any user that will modify the Parent List? (OR) Just for your account?
I.E. is the Flow assigned to the list, or (only) your account?

Thank you.

This is great. would it be possible for me to change the number that is added or subtracted to something with a decimal? I need to add by .0001

Because you only have one Item in Child list you only get one email. I have hundreds of items and I received hundreds of emails. The "Send an email" needs to be placed outside the "Apply to each". But thanks anyway :)

Hi Danel. Thank you so much for the video. But am facing some challenges here. Can you please explain how I can compare email address on the two list instead of number/integer

Great video thank you! I have a question for you if I may ask, my SP List is all good, but I have one column that I want all the information/comments to be displayed under the same row ( the history ) in case someone adds a comment or info, with append changes it only shows ''View entries''. Is Get item the solution for my issue? Thank you.

Thank you very much for the demo. I just need to loop through list A and get an item based from an item in list B. I've been looking everywhere, but they cannot be easily understood.

do you have the video using sharepoint designer with the same scenario

Daniel - this is brilliant! It enabled me to work out how to do something similar which didn't seem like it should be complicated but which I couldn't find any Microsoft documentation for. Thank you.

This is great, thank you.  I have been struggling with getting flow to do anything more complex than sending an email when a new document is added.  You have set me on the path to do useful things.