Use power automate to check if the records in table A exists based on the info from table B

[Sophie_Jin]

Hi,

I have two table in Model driven app, Table A and Table B. 

1. The relationship between A and B is 0/1 to many. 

2. In Table B, there is a lookup field to link to table A.

3. Both tables have a common field which can be named as Common field

Goal:

The records from B were imported from excel. when new records get imported in table B, the system needs to check the related record in Table A exists or not.  How to achieve it with power automate?

Thanks

[SimnaJ · Accepted solution]

You can achieve this goal by creating a Power Automate flow with the following steps:

1. Use the "When a record is created" trigger to monitor new records being added to Table B.

2. Retrieve the value of the common field for the new record created in Table B.

3. Use the "List records" action to search for a record in Table A that has the same value for the common field. Use the OData filter query to find a matching record.

4. Check if a record was found in Table A. If a record was found, then the related record exists. If no record was found, then the related record does not exist.

5. Based on the result, you can take the appropriate actions, such as sending a notification or creating a new record in Table A.

Here's an example of an OData filter query that can be used in the "List records" action to search for a matching record in Table A:

_commonfield_value eq '[Common field value from Table B]'

Replace [Common field value from Table B] with the actual value of the common field for the new record created in Table B.

If you feel that my response has helped you, please mark it as the solution and please consider giving it a thumbs up. This will help other community members find the solution quickly if they have a similar issue in the future.