Hi All,
I'm trying to create a flow that creates or updates items on my child SharePoint list depended on the parent SP list.
Here's what the process looks like (the bold is where the workflow begins):
User fills our MS form>Creates item in Parent SharePoint>Updates child SharePoint
Currently I'm using a condition which compares the title (email) column of both list. I want a condition where one of two happens:
If title (email) matches: Update/overwrite existing entry on child list.
If title (email) doesn't match (no entries listed): Create new line item.
I'm having an issue now, where no matter what I do, the condition is triggering as "false" and a new line item is created on the child list, even if there is an existing item to be overwritten with a matching title (email). I've tried switching the Update/Create with the Yes/No conditions and it still defaults to false and creates a new line item.
Would appreciate any help I can get on fixing this or creating a flow where responses will overwrite previous responses from unique users or create new ones if none exist.
Admittedly, I am not formula savy, so please expand a bit if that is required. Thanks so much!
Below is my current workflow:
Solved! Go to Solution.
Hi @Unity ,
Please refer to screenshot below to create the flow:
The expression in the Filter Query in the Get items action as below:
Title eq '@{triggerBody()?['Title']}'
The length expression in the Condition as below:
length(body('Get_items')?['value'])
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be a Flownaut!
Hi, I currently only have 2 items on the child list. The parent does have 150 entries. That wouldn't be the issue then with the low number count right?
Cheers
Hi @Unity ,
Please refer to screenshot below to create the flow:
The expression in the Filter Query in the Get items action as below:
Title eq '@{triggerBody()?['Title']}'
The length expression in the Condition as below:
length(body('Get_items')?['value'])
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
works like magic, many thanx!!!
User | Count |
---|---|
93 | |
46 | |
21 | |
18 | |
17 |
User | Count |
---|---|
144 | |
51 | |
42 | |
40 | |
31 |