Update an item column in a list through forms

(0) Share

Report

Posted on by PM-13052142-0

189

Hello Community

I´ve created a flow in which someone can fill out a form with some specific values. The user gets an email to confirm the information and after that, an item is created and the flow sends an email with what was filled in.

Despite the user gets an email to check the information submitted, before creating the item, I´ve realized that items are created with errors and the user fills in the form which creates another item, leading to have a list populated with unnecessary data.

So, I was wondering if there is a way to update a value in a colum but... here is the trick. The item has lots of columns that can be updated so, may be one user wants to update his email and another user wants to update his birth date. So each user can update any column whitout affecting the rest of the information.

I managed to update the item by calling its ID but the user has to fill in the entire form again (leading into unforced errors). My idea is that the user only updates specific values without going through all the form. I´ve seen researched http request but still quite don´t understand the approach I should have.

Categories:

Building flows

I have the same question (1)

All responses (8)

Answers (2)

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report

Hi @PM-13052142-0,

Can you share a bit more details about the setup? What type of form are you using for the updates, is that a Microsoft Form? And what are you using for the list, I assume a SharePoint Online list?

A couple of screenshots would clarify a couple of things and would help with making a suggestion for a solution approach.

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
PM-13052142-0 189 on at

Like (0)

Report

@Expiscornovus

Im currently using Microsoft Forms and Microsoft List (SharePoint).

Just to be more consice, what pictures do you need?

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report

Hi @PM-13052142-0,

Thanks for the reply, that helps. Yes, you could use the validateUpdateListItem method in a Send an Http request to SharePoint action to update just a single column:

https://tomriha.com/update-single-sharepoint-column-in-power-automate-with-http-request/

Btw, I was talking about a screenshot of your current flow setup

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

1 people found this reply helpful.

Was this reply helpful? Yes No
S-Venkadesh 927 Moderator on at

Like (2)

Report
Hi @PM-13052142-0,
Please check if this approach works for you:

When a new response is submitted in Microsoft Forms, create a new SharePoint list item with the Status set to “Draft.”

Send an email to the user containing a link to the SharePoint list item. This allows the user to update additional details such as email, birthdate, etc.

Once all required information is updated, change the Status to “Active.” You can also include additional logic between these steps if needed.

Note: You can also try adding an AI Prompt that extracts user information and outputs it in the desired JSON structure. The resulting JSON can then be used to automatically update the details in the SharePoint list.

Hope this helps! 👍
Regards,

Venkadesh

Was this reply helpful? Yes No
Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (1)

Report

Hello @PM-13052142-0

I agree with @S-Venkadesh as I do the same thing. I send an email that does 2 things

1. Lists the specific item they created (via the form)

2. I also provide a link to filters all theirs if they want to just see theirs all at once.

In this instance you can also create a SharePoint custom form which would make it a littler easier (imho) to update as the long vertical standard form stinks (again imho) lol

Was this reply helpful? Yes No
PM-13052142-0 189 on at

Like (0)

Report

S-Venkadesh

I´ve already gone to that way but nevertheless, when the user has to validate the information, they fail to do so because they just click ok and don´t read what is going on. That is why I decided just to create the item when they validate the info (did I mention they don´t read lol).

I will explore Expiscornovus approach. I´ll show some pictures of my flow, please let me know if you have any more questions.

This condition validates the user input

After that if data is OK (Datos OK) it will create the item and populate it as per what was filled in

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (1)

Report

HI @PM-13052142-0

One reason I said to create a custom Form so that you can stop them from clicking OK until everything is valid. A custom form via Canvas "App" which is... just a page mostly, you can literally block out the ok button until the fields are valid.

When you redirect them via Email, OR when they go directly to the list... use a custom form and now they are blocked.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No
Verified answer

PM-13052142-0 189 on at

Like (0)

Report

@Expiscornovus

I managed to perform the update.

One thing that I had to adjust before the update, is the date format that was passed from Forms to the Item (from yyyy-MM-dd to dd/MM/yyyy). The item was not updated despite the flow ran successfully, because two field values had the incorrect date format.

Was this reply helpful? Yes No