Good Morning all.
I have a Form that includes the following information. Date, Office, Loaction, Manager, Model, Serial and Asset
The Form needs to update a SharePoint list. If the Asset is not currenty recorded a new item should be added to the list. If the asset is there already then that item should be updated. The Date, Office, Location and Manager are able to change while the Asset, Model and Serial number would always stay the same.
I have tried to build a Flow that will collect the form data, reference the SharePoint site and either update the existing record based on Asset or add a new entry.
Can anyone help me with a reccomendation on a flow to use? I would think something like this would be rather common but can not find any examples...
Thank you,
Adam
Solved! Go to Solution.
Hi @AdamWeinstein ,
Do you want to create a new item in SharePoint list if it doesn’t exist, otherwise, update the existing item?
I have created the following flow for your reference. In my scenario, name from Forms has common value with Title from the list, and would always stay the same.
Best regards,
Mabel
Hi @AdamWeinstein ,
Do you want to create a new item in SharePoint list if it doesn’t exist, otherwise, update the existing item?
I have created the following flow for your reference. In my scenario, name from Forms has common value with Title from the list, and would always stay the same.
Best regards,
Mabel
Hello,
With a few minor tweaks we got it to work as needed. This might be a useful template for people that want to use a form to create or update an item on a list.
Thank you again,
Adam
Hi Adam,
Did you use a SharePoint list as a source for this? If yes, can you please share the logic or screenshots of the workflow? I am trying to achieve the same and have some issues.
Thanks,
Santosh
I am not sure this works anymore, The first "Apply to each" the output "list of responses" is no longer an option. Is this a bug or a change? if so is there an updated method for updating an existing list library from a form submission?
thanks
Hi,
In this flow for "Get Items" what should be mentioned in Filter Querry?, as it can't be left blank.
Facing same issue
User | Count |
---|---|
89 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
38 | |
24 | |
21 |