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

PowerApps connection update item

 
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

 

 

Hello @jay312 ,

 

The issue with using Lookup fields in the list is that there is referential constraint associated with it.

You cannot have other emails in List01 without it being present in List02.

If you can convert that column to be regular text field instead of a lookup. You can still have a separate flow for auto-populating the city field in List01 based on List02's city value.

Please consider having a another flow which looks like this:CommunityFlow.PNG

View solution in original post

17 REPLIES 17
Community Support
Community Support

 

@jay312 ,

If you have a lookup column in SP list. If you go to list settings and open the column details.

You should see an option to display the auto-populated field there.

PAC1.PNGPAC2.PNGPAC3.PNG

 

 

Can you consider using such auto-populate field that already comes with the SP list?

Hi @vikulkar 

 

I did not consider the look up option within SPO..

 

Do you know if that will accomplish the same goal? i.e if xyz@mail. com exists in List 2, then use the specific city value for email xyz@mail.com. If zzz@mail.com exists in list 2, then use the different city value for zzz@mail.com? 

 

Is it easy to set this up? 

Community Support
Community Support

 

 

Hi @jay312 ,

 

Yes it should work, make sure you provide the id value of xyz@mail.com/zzz@mail.com in your flow

based on the id, the city field will be auto-populated.

 
Community Support
Community Support

Hello @jay312 ,

In my example List 01 has a email column which is a lookup that refers to List 02 which has the city value.

The city field in List 01 gets auto-populated when in PowerApps(connected to List01), the email field is filled as the screenshot shared below. there should be no necessary for a flow here.

List01.PNG

 

List02.PNGLookupPAFc.PNGPA1.PNGPA2.PNG

Hello @vikulkar 

 

Thank you for reply 🙂 few qs please

 

  1. If i got rid of power apps all together and just use a default SPO list -> Still OK?
  2. I need a flow because the trigger will be 'When an email arrives in a shared mailbox, create an item on a SPO list'
    1. Using the 'From' person in the email, I will make a flow to 'Update item' and change the 'Email' column in SPO list to the 'From' sender from mailbox. 
      1. I would want the look up to see that Email is now autopopulated by flow, so should the City field automatically be looked up? This process works manually but I dont know if getting flow to autopopulate 'email' will trigger the City field to automatically look up. 

I will test this now to see but hopefully that makes sense.. 

 

 

 
Community Support
Community Support

 

 

@jay312 the below flow should help: 

since the column in List 01 is a look column. You will have to make sure you pass the id and not the email directly.

hence GetItems on List02 with a filter query should do the job.

If you pass the id, yes it should auto-populate the city field in list01

 

flow05.PNG

 

 
Community Support
Community Support

 

@jay312 :

Assuming that you are looking on how to implement the 3rd part.

One way to achieve this is by setting the flow like this:

Before creating an item in List 01. I would getItem from list 3 by filtering based on the city in List 2 (which is same as the auto-populated one). after I get that I will create the item for List 01 by setting the 'Assigned Trainee' field

 

PAC4.PNG

 

 
Community Support
Community Support

 

 

Hello @jay312 ,

 

The issue with using Lookup fields in the list is that there is referential constraint associated with it.

You cannot have other emails in List01 without it being present in List02.

If you can convert that column to be regular text field instead of a lookup. You can still have a separate flow for auto-populating the city field in List01 based on List02's city value.

Please consider having a another flow which looks like this:CommunityFlow.PNG

View solution in original post

 

Hello @vikulkar .

 

The column name was the issue!! I just changed it in flow from City L3 to just 'City' and the flow ran fine.. ! Thank you

 

I am just trying a few other steps and will keep updated. And will try other test cases.. Thank you 🙂

Community Support
Community Support

 

Hello @jay312 -

 

Glad to know that the flow is fixed!

If you just have a quick question related to this, use this thread but for any new separate issue please start a new thread.- as this will help our PAF community with readability. 

 

 

ignore deleted

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

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 (55,172)