
Hi,
I am having trouble with creating this flow.
I have 5 lists: A,B,C,D,E - all of them are the same. There are 2 columns that we need to focus:
1) ID - standard ID field
2) MyID - ID we made to have real unique ID between lists. Formula: [ID] & [ListName]
There is also main lists - that combains all records from those 5 lists above. Here comes the problem:
When I try to make flow that updates main list - based on MyID (the only possible value) - I can only choose [ID] - the standard ID witch will be diferent. For example:
First record from list A has ID = 1. and MyID = 1A, but this record on main list has ID= 3, and MyID = 1A.
How can I make flow that identyfy rows by MyID instead of ID
Any help will be aprociated 🙂
Hi @PowerAppsUser4,
You could use the Get items + Filter query to approach that:
1. Get items from the listA, filter query to find the MyID column value equals to 1A;
2. Update item with the return ID to update master list.
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.