Update list item depend on another list item creation

[gautmish]

Hi

I have a list A and And List B

Employee Email is common between both.

On item creation in List A , I want to update List B detail of same employee

I did it in powerapps . Please help me to achieve in Flow .

Thanks

Gautam

[ScottShearer]

I assume that you are referring to SharePoint lists.  I am not sure if the email address is stored in a person or group column or in text boxes, so I created examples for both.

Here is an example that uses SharePoint person or group columns:

Here is an example that assumes that the email addresses are stored in text columns:

If these require additional info or I am not on point, please post here and I will respond.

[v-xida-msft · Accepted solution]

Hi @gautmish,

Could you please share more details about your two SharePoint lists?

Do you want to update the same employee within List B based on Employee Email?

I have created List A and List B on my side and the data structure of it as below:

List A:

List B:

Note: The Employee Email column is a Sinle line of text type column within List A and List B.

I agree with @ScottShearer's thought almost, I assume that you want to update the same employee within List B based on Employee Email when an new item is created in List A, I have made a test on my side and please take a try with the following workaround:

• Add a "When an item is created" trigger, specify Site Address and List Name set to List A.
• Add a "Get items" action, specify Site Address and List Name set to List B. Within Filter Query field, type the following formula:

Employee_x0020_Email eq 'Employee Email Dynamic content of the trigger'

Note: The Employee Email dynamic content is wrapped with single quotes.

• Add a "Apply to each" action, input parameter set to output of "Get items" action.
• Within "Apply to each" action, add a "Update item" action, specify Site Address and List Name set to List B. Id field set to ID dynamic content of "Get items" action, Title field set to Title dynamic content of the "Get items" action. These fields which you want to update set to corresponding Dynamic contents of the trigger.

Image reference:

The flow works successfully as below:

 

Best regards,

Kris

[ScottShearer]

Kris:

The reason that I did not use the filter query option is that I do not see Employee Email as an option available in Dynamic Content when creating the expression.  I only see EmployeeEmail Claims, Display Name, etc..  I tried for quite a while to work around this when creating my solution without success. 

Can you confirm that this option (just the person or group column name) should be available for SharePoint person or group columns for all Flow users?

In the screenshot below, EmployeeEmail is a person or group column.  The column is configured for people only and not to allow multiple selections.

Can you tell me what I might be missing?

[AmanKumar_007]

@gautmish, Could you please share the details with me that how you have done it from PowerApps ?