Perfect!! I was looking for a way to change one value field in a list containing over 16 fields, and using an 'Update Item' control was tedious. I could not find anyone else explaining how to update a single value until I found your tutorial. Thank you so much for sharing this information.
Just a small observation (you helped me out so much, can't thank you enough): if you are messy with how you handle naming your files (or lists in this case), please remember that renaming your list will not change its URL from the one generated upon creation. Mine was named "Test Call-Ins" at first, then I renamed it for the department to "Dept Call-Ins" so the compose action Paulie listed wouldn't work unless I told it to refer to the "test" name.
This is all great but it would help a lot if you'd expand the "get item" card, I understand that this is obvious for experienced flow builders but without this for newbie the rest of the flow is useless.
Hi Paulie, Thanks for another informative video, can u make a video on Dataverse - Power Automate integration as well on how to fetch records more than 5000 from dataverse
Hi Paul, I need a help with power automate. I have a sharepoint list. Once a list is filled up, I have a power automate flow that creates a planner task. Now when the planner task is completed, I want to update the sharepoint list, marking it complete. I am struggling with creating this flow for updating the list. Can you please help?
This is all new to me and this video is GREAT! But, I have a question. I am having to update a field for just one item in the list. I followed your instructions but it is taking a long time so I'm concerned that instead of updating just the one item, it might be updating the entire list. I did a little more testing and I think my issue is that I'm updating a on premise list going through the On premise data gateway so I am trying to connect to the list but it's not finding it.
Would it be possible to use Power Automate to sum the entries into the list on a given day and remove the duplicate entries? We use SP to capture stock taking - 3 columns [SKU; Qty =1; Date]. All the user does is scan the items into the list, then we have to use excel power query to merge and update the list before we can update Stock on Hand in another list.
Thanks! Spot on with the blog and the video.
Perfect!! I was looking for a way to change one value field in a list containing over 16 fields, and using an 'Update Item' control was tedious. I could not find anyone else explaining how to update a single value until I found your tutorial. Thank you so much for sharing this information.
Glad it helped. It’s actually really frustrating to update a row that has a lot of fields.
Very efficient. Thank you for this resource. Much appreciated.
Just a small observation (you helped me out so much, can't thank you enough): if you are messy with how you handle naming your files (or lists in this case), please remember that renaming your list will not change its URL from the one generated upon creation. Mine was named "Test Call-Ins" at first, then I renamed it for the department to "Dept Call-Ins" so the compose action Paulie listed wouldn't work unless I told it to refer to the "test" name.
Many thanks! Best tip I've come across in some time.
Just what I wanted to learn. Thank You.
You’re most welcome
This is all great but it would help a lot if you'd expand the "get item" card, I understand that this is obvious for experienced flow builders but without this for newbie the rest of the flow is useless.
Thank you for this very helpful video. Is it possible to update a date column with a utcNow() function?
Thanks!
Hi Paulie,
Thanks for another informative video, can u make a video on Dataverse - Power Automate integration as well on how to fetch records more than 5000 from dataverse
Hi Paulie. How would you update a Person type?
Hi Paul, I need a help with power automate. I have a sharepoint list. Once a list is filled up, I have a power automate flow that creates a planner task. Now when the planner task is completed, I want to update the sharepoint list, marking it complete. I am struggling with creating this flow for updating the list. Can you please help?
Can you also do this for document library column values using "Update File Properties" in place of "Update Item"?
I haven’t tried it - did you attempt it?
@@PaulieM I've tried but been unsuccessful.
@ I will have a look soon but I’m not using my computer during the Christmas break really.
can we add values multichoice persontype columns Through Batch update flow???
This is all new to me and this video is GREAT! But, I have a question. I am having to update a field for just one item in the list. I followed your instructions but it is taking a long time so I'm concerned that instead of updating just the one item, it might be updating the entire list.
I did a little more testing and I think my issue is that I'm updating a on premise list going through the On premise data gateway so I am trying to connect to the list but it's not finding it.
I have not tried it with an on-premise SharePoint instance, so I cannot be of much help I am afraid.
Hi there!, thank you for your video, its very helpfull. I can't set user column, may you give an idea? Thank you
Would it be possible to use Power Automate to sum the entries into the list on a given day and remove the duplicate entries? We use SP to capture stock taking - 3 columns [SKU; Qty =1; Date]. All the user does is scan the items into the list, then we have to use excel power query to merge and update the list before we can update Stock on Hand in another list.
Yes. It would be possible.
What if you need to update a different list?
can i specify if i have multiple rows ?
You’d have to do it within an apply to each
why do you have a "Get item" before updating the list?
So I could get the unique ID of the item I wanted to update.
Office 365 is full of small secrets.
This is helpful however, I don't know how to set up the "output" step
Hi Cat,
Please create a post on powercoders.net explaining what you do not understand and I will answer you there.
what about lookup column?
nvm i found how to update it
Care to share?