cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Update list item depend on another list item creation

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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:28.JPG

List B:

29.JPGNote: 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:30.JPG

 

31.JPG

 

The flow works successfully as below:32.JPG

 33.JPG

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Super User III
Super User III

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:

FlowEmail1.pngFlowEmail2.png

 

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

 

FlowEmailA.pngFlowEmailB.png

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

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Community Support
Community Support

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:28.JPG

List B:

29.JPGNote: 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:30.JPG

 

31.JPG

 

The flow works successfully as below:32.JPG

 33.JPG

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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.

 

PG.png

 

Can you tell me what I might be missing?

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Frequent Visitor

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

Helpful resources

Announcements
New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (46,761)