I need some assitance and guidance.
Have several columns, 1 multivalue select, 1 title, and several general text columns. This list may have mutliple entries with the same title. For example: I enter data in the list and give it a Title like Duane Test. I then add a new item a week or so later, I use the same title of Duane Test, but update the other fields. (I am using a direct url for new list item for end user convience). So there may be several or dozens of entries for the same title.
I would like to copy the data from the Title, and several text fields to another list, but I would like to only create 1 row for each title and update the row if it changes in the source list.
Single row, that is updated if changes recorded in List 1 based on the Title
copy some of the fields from list 1 to list 2, but not all.
At this point the flow runs successfully, but no updates are being done in list 2 (meaning no new entries or updates). the list is blank, evern after several flow runs.
I would restructure Flow as follows:
You'll be inside of a loop when you create or update the item but only 1 item should be returned.
Let me know if you need an example
Thanks Scott! I will try that. I removed the Apply to each and Value from the create item and ran the flow again. it created 1 new record, evern though there are about 4-5 other unique (non duplicate titles) - it did not create those items.
I will now test your suggestion and post a reply. thanks!
is this the proper way to do the OData filter on Get items? The flow runs sucessfully, but no changes are made to the list... even though there are several other unique titles in the source list.
You need a space after Title and before the single quote.
Also, Here is an example of how I suggest configuring Get Items and the condition that follows:
If no items are returned, create a new item.
If an item is returned, update it.
If this works for you, please mark your post as Solved.
THANK YOU SO MUCH for you HELP!!!
It is mostly working now. I made the changes you suggested - and now I have the additional entries.
But when I add a new entry and use the same title and update the Week 2 Points column (on the first entry this column was empty) , but this time I leave the Week 1 Points and Week 3 Point empty - it creates a new entry instead of updating the existng entry.
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!
Check out the community blog page where you can find valuable learning material from community and product team members!