Submit Form to create and modify SharePoint list

(0) Share

Report

Posted on by diegoandre10

517

Hi all

I created a flow when a response item is submited to update a sharepoint list.

test form.PNG

The form has 3 paths.

New project: add status, % completion, date of completion.

Status update: add status, % completion, and the project ID

New target for completion date: add the project ID and new target for completion date

date form.PNG New form.PNG update form.PNG

The flow is here detailed:

flow form.PNG

The problem I have with the flow is that it adds items but it does not modify existing items on the sharepoint list. For example if you select the option status update or new target for completion date, if you enter the existing project ID on the sharepoint list and fill the rest of the data, the sharepoint list wont update, it will add a new item

So the question is, how to update an existing item in sharepoint list when I want to give an status update or enter a new target date.

Regards.

Categories:

Building flows

I have the same question (0)

All responses (22)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @diegoandre10

This is because in the flow, you are not checking if the response in the form is Status Update/ New Target completion date. What you need to do is, before the Create a new item action, add a condition to check if the Type of project is either Status Update or New Target Completion date. In the yes branch, add an action Get Items and in the filter query of the list items type ProjectId eq''. In the single quotes, select the project ID from the dynamic selector from the response of the forms. I am assuming that the Project ID will be unique all across. Now, add an action to update an item and in this for the ID select the ID from the dynamic selector under the Get Items outputs. This will add an apply to each loop (but as the project ID is unique there will only be one value)In the update action map all the fields accordingly.

In the no branch of the condition simply add the create item action as you have in your flow right now.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report

Hi @yashag2255

Thanks for your help

I did some changes in the flow, however I didnt fully understand the logic I have to follow in the flow.

First of all, the condition. What should be the conditions?

I placed an or, so if project ID is not equal to null (for both Status update and target for completion date) then get items, if not, create an item.

On the get items query, what should I use there?

Also for the update item icon, What should I use for the ID*?

Just in case, I have 2 project id's in my form (yes they are unique). The reason to have 2, it's because of the branching. See below:

Thanks

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @diegoandre10

Please see the screeshot below:

Here, you need to actiallu write the choices in the condition action. Then after the get items action, you can add the udpate action and reference to the ID from the dynamic selector. Note that you need to find the column that has unique values in order for this to work (makes sense?)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report

Hi, my equivalent to Question in the condition would be the Status updte or New targer for completion date

However, on the dropdown dynamic menu, they dont appear as seen below:

I tried wtitting them down manually under the dynamic content or expressoin but they wont show up

Thanks a mill.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @diegoandre10,

I have tested on my side and the type of project appeared.

After you modified your MS Form, you can save your Flow and then reopen it, the dynamic content will appear.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report

Hi

The Flow now is not having an error, which is good. Howver when I do a status update or enter new target date (choice 2 and choice 3) it creates items in the sharepoint list intead of modifying.

I guess the flow is not understanding choice 2 or choice 3:

We are getting closer.

THanks @v-litu-msft

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report

I changed the condition names to the actual ones I have in the form:

The new project works, but the update item wont:

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hey @diegoandre10

In the filter query you need to write the ColumnName eq '' In the '' select the dynamic content for the forms here. Note that if you have spaces in the column name e.g., column name => column_x0020_name eq ''. (you need to replace all the spaces with _x0020_)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report

Hi

If you mean the column name of the sharepoint list, I did this:

I entered the project ID because it's the value the has to be replaced. 2 different project ID depending on the status update or new target for completio date.

Sorry if I did not understand correctly

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hey @diegoandre10

Not like that. So you will have to get the column name from your sharepoint list and check the forms output with that. Please see the screenshot below:

Here, ProjectName is the column name on SharePoint and I have chosen the Project Name field from the forms' response. Makes sense?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No