Power Platform Community Forum Thread Details

Hello,

I have a situation where I need to remove certain IDs from the UserGroupStatus list if they no longer exist in the TB_FORM list. In the UserGroupStatus list, the TaskID column contains a comma-separated list of IDs (e.g., 18, 17, 5). My goal is to remove the IDs that do not exist in the TB_FORM list while keeping the ones that do.

For example, let's say I have the following values in the UserGroupStatus list's TaskID column: 18, 17, 5. In the TB_FORM list, I only have one record with the ID 5. In this case, I would like the Power Automate flow to remove the IDs 18 and 17 from the TaskID column, while retaining the ID 5 since it exists in the TB_FORM list.

One important detail to consider is that the IDs in the TaskID column of the UserGroupStatus list are separated by commas. For example, the TaskID column might contain values like 7, 17, 8, and so on.

Could you please help me with the Power Automate configuration to achieve this? I would greatly appreciate any guidance or suggestions.

Thank you!

Categories:

Building flows