Hi all
I have created 2 forms with one question each. Basically it's an "I agree terms":
Forms 1:
Forms 2:
On the other hand, I have a sharepoint list that contains the columns to retain each of the answers.
What I would like to see if it's possible is to have the flow update/create the column values whenever the title is the same.
In the example above, the title (disaenz) are the same for both rows, so the expected result would be to have only one row with the "I have" in column vision and "I have" in column how are we organized.
Here are my 2 flows:
flow 2:
How can I get one row sharing the results of both forms when the title is the same?
Thanks!
Solved! Go to Solution.
I think i missed this, your condition should be different:
Here are steps:
- Get Items with Filter query -Title eq '<Response from FORM>'
- Add a condition action to check if Get Items returns any result:
Hi @diegoandre10 ,
You need to create two flow to update these two fields.
Both Flow structures are the same, you only need to change the Form id. When configuring Create item action and Update item action, only the specified fields need to be configured.
Hope this helps.
Best Regards,
If title is unique then you need to add a Get Items action in your second flow and query the list where Title is equal "unique Title value" , if title exist you will get the details and you can use Update item action. If not exist you can create new item.
Regards,
Hi @DeepakS
Thanks for the help!
So I did a test and partially worked. It added the item in the same row to the column called "how are we organized" for disaenz. The "I have" for the column "vision" was already created and therefore a title existed.
However it didnt work when it had to create a new item when the flow did not find an existing title.
This is my flow:
In other words, my if no statement to "create the item" does not work when there is not an existing title.
What do you see wrong?
Thanks a lot!
In Create Item , make sure you use Title and other details that you get from Form instead "get Item" Action.
Regards,
Hi @DeepakS
Not sure I got you on that one 😞
This is the form (1 question):
The create item has the title (responder email), the "vision" field is empty because that's an answer from the first form, and the "how are we organized field" has the answer from the form:
Thanks!
In Create Item action you should assign Title to response received from MS FORM ,how you were doing earlier in create item .
Hi @DeepakS
I changed it and still didnt create the item:
Could the problem be the if condition were title is equal to title?
Here is the test flow, the condition is grayed out:
Thanks again!
I think i missed this, your condition should be different:
Here are steps:
- Get Items with Filter query -Title eq '<Response from FORM>'
- Add a condition action to check if Get Items returns any result:
Hi @DeepakS
Should the get items go after or before "get response details"?
I did the title and was prompted to enter "List of response notifications response id". is the correct?
Second thing is the code you gave me to be placed in the condition. Where should I type it?
I did it like this:
Thanks for your time!
Hi @diegoandre10 ,
You need to create two flow to update these two fields.
Both Flow structures are the same, you only need to change the Form id. When configuring Create item action and Update item action, only the specified fields need to be configured.
Hope this helps.
Best Regards,
It worked!
If I understand correctly, the length(body('Get_Items')?['value']) = 0 counts the items on the sharepoint list. If title is zero you create, otherwise you update.
Awesome!
Good to know you fixed it, i was actually about build your flow at my end 😉 you save my time.
Reagrds,
DS
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
39 | |
36 | |
34 | |
32 | |
27 |
User | Count |
---|---|
46 | |
36 | |
33 | |
25 | |
22 |