How to create a SharePoint list item with lookup field using Power Automate (MS Flow)

In this video you will learn how to create a SharePoint List item using Microsoft Power Automate (Flow). This video uses ODATA and Power Automate expressions to produce a clean design for the solution.
Check this video to learn about ODATA and Microsoft Power Automate
• Using OData Filters in...
Master Microsoft Flow Expressions in 2 hours (Udemy course)
www.udemy.com/course/master-m...
LinkedIn:
/ alirezaaliabadi
Twitter:
/ aaliabadi1
Instagram:
/ alireza.aliabadi_ig

[@RickyFaulstich]

Fantastic tutorial. Very nice explanations and incremental demos/tests of each step. I was just trying to pull in MS Forms responses into SharePoint (with lookup column,) and this was a perfect tutorial. (Especially liked the tip of getting rid of the foreach.) Looking forward to check out the rest of your channel (expressions, json!)

[@draushaus912]

Best tutorial I've seen on this topic. But not yet what I need. I have a main Microsoft List that is populated from Microsoft Forms. The Microsoft List has two lookup columns (and other columns). I need to populate the columns from the form and then get corresponding information for each of the lookup columns from another Microsoft List. Not clear on whether what you have here will work.

[@sashawarchoon1989]

It’s inspiring how dedicated you are to what you are doing. I mean that it’s unlikely you run this channel to make money because number of views and subscribers is relatively small. Looks like you are truly dedicated and that’s cool!

[@AlirezaAliabadi]

You are right but not completely. I didn't build this channel to make money, but it has helped me a lot financially. Not through KZbin ads, but from publicity and credibility. I am a consultant and this KZbin channel has helped me land many contracts. I also use it to see what topics sell better and build my Udemy courses based on the feedback I get from KZbin. Thank you for your comment. In the end inspiration of viewers like yourself make me continue the work.

[@barunroyghatak4380]

@@AlirezaAliabadi Great reply sir

[@elainechang646]

That was so helpful. Very clear explanation and structured in a way that is easy to understand- building concepts up in complexity. Also very entertaining. Thank you!!

[@cristoumanzor3896]

I learned something new today! Thanks a lot for your very clear explanation. I do encourage you to carry on!

[@keemalcan94]

Your video has been very helpful. Thank you!

[@ChristianDepnr]

The Best

[@no.more.official]

Thank you , i was stuck

[@jagdeesh9338]

Your videos are clean and clear

[@OpusMagnoCards]

Bravo Ali!! Thanks for such a fantastic tutorial and explanations. Keep up the good work!

[@naveensadasivam1738]

Thank you very much Ali. This was very helpful.

[@anusha0524]

Thank you for this helpful video.

[@mikewauke5626]

Thanks for this helpful tutorial. May I ask one question: How is the syntax when it comes to multivalue lookups via Power Automate?

[@sundrapillay6668]

Thank you so much

[@ramonillarramendi3191]

Great video Alireza. Thank you very much for a clear and great explanation. One question, I have two lists, Parent / Child lists. The parent list contains requests, which have to be later approved. The child list contains one or several subitems of the parent request (linked by a lookup value to parent). The idea is when a user creates a new request, he fills in the request info (Header) with basic information, then he creates one or several records or subitems with the detail of the order (position or referenced item) in the child list. The final idea is to have an approval sent by email per parent record, so I'm trying to update a field in the referenced parent record with all the subitems of the order, but I'm having trouble with flow. Can't get to update the record. Is there a simple way to do this?

[@chiragdhameja6674]

Hi Alireza, thank you for the video. how can I change the manually trigger a flow to automate once I drop the folder/file in the library? Thanks

[@barunroyghatak4380]

Very nice video sir. Thankyou. I have subscribed your channel

[@pbxxx]

I have a Flow that I created that automatically triggers when an item is created. The flow goes and matches the value in one field, goes to another list and copied several columns over. Right now I am the only user as I am testing my site. My question is: If another user (Jane) creates an item in this same list and the flow runs under my ownership (Cody) -- will my name show up as "Modified By" or will it still show her name?

[@connyschroeder9820]

Great tutorial. I am having trouble copying a lookup column with multi selections from on list to a lookup column with multi selections in another list, I do it in the same way as if it was a choice column. It says the column is read only. What am I doing wrong - or isn't it possible?

[@alainbrouers7248]

Hello, Thanks a lot for your video which helps me a lot. Could you just explain me how to do the same process but base on a Excel sheet which contains all record I would like to store in Sharepoint ? I try to put the get item step into a apply to each but it doesn't work. Thanks you some much and have a nice day.

[@saivad49]

i have 2 list , Department list and document list, I have a column “department name “ type of look up in document list, which 7 department, any department has a responsibile to approve the file, how can i create a flow in the first level and send approval email to who is responsible of the department, i mean assigned to group dynamiclly who is responsibile that has been selected for that file. please i need your help 😓 i dont know assign part

[@Rameshkumar-cr6ic]

Hi Bro . its was such an good video. i have created one sharepoint list . i want to automate that whenever list is created the mail should goes to some of the recipients. But in the mail list item should view .. can you help me pls..

[@manmohanjha6871]

Hi Alireza, Nice video, I have a scenario in which we are trying to import Sharepoint list in SQL using Power Automate, but we are missing fields which are record type, can you guide how we can do this ?

[@akbarmahfuzalam]

Hi Ali, Can we Create a dependent Combobox for the user

[@MarkChinsky]

Could you do a video showing how to add a value to an HTML table from a related data table that has a 1-1 relationship? I'm using Dynamics 365 Customer Engagement (CRM) and am outputting data from the Opportunities table, but need to pull the Customer Name from the Account Table into the HTML table since internally it shows as a complex 16 digit key. I would have thought there was a simple 'lookup' command in 'Dynamic Values' but I guess that would be too easy.

[@manikantar5848]

Hi Ali Reza, I have an issue in getting the current attachment from the loop and send that to email. Is this something which you can help

[@sahilshah3594]

what if the trigger is not manual and user do not enter category value manually

[@bobleach]

Thanks for this really helpful - I've subscribed to your channel. I thought you said your udemy course was free? Ive clicked on your link and wants to charge me. Are you likely to make it free again?

[@AlirezaAliabadi]

Course vouchers expire after certain days, for this month I still have a few free vouchers for Power Automate expressions. Message me on LinkedIn and I will send you the code.

[@carlw]

Thanks, great first step! Now, if you have a larger list with longer names, NO ONE will remember the actual lookup values, nor should we have to. We have a lookup in SharePoint for a reason. Now we step back trying to make things simpler and remote but end up making things more precarious. In that case, if you're wrong EVERYTHING becomes "Miscellaneous". Have you figured out how to crack it so that the user has an input that provides an actually list of items to choose from. Yes we can have that simple little 'text input' as category, but the variable assigned needs to be pulled from the actual list, and show the list, not the user blindly entering anomalous values. Microsoft needs to include that in the "Input trigger". They think we all only use simplistic text boxes and anything beyond that requires a degree in computer science to figure out. Tx CW

[@AlirezaAliabadi]

That input trigger is already there. Check Power Apps :)

[@carlw]

@@AlirezaAliabadi Thanks Alireza. Sorry, not sure what you mean by checking Power Apps. The Button trigger in Power Automate, in addition to text, number, date etc. inputs only provides a lookup list you have to populate manually. It doesn't provide a way of choosing a value from a lookup a list. Is that what you mean? Also, for your interest, another gentleman Aniruddha Biswas is working on a similar technique: "Upload Any File from PowerApps to SharePoint Library" kzbin.info/www/bejne/paPGaJmPgMh6rrc Cheers

[@shiijupy]

calculated columns in SharePoint lists not showing the updated values. what's the solution for that.

[@widuralatest]

Hi Ali. Could you please post the link to the JSON course?

[@AlirezaAliabadi]

Sure www.udemy.com/course/json-crash-course/

[@sreenumarneedi2627]

Can you please help , How to check condition for date fileds like Greaterthan Or equals (>=) using flows

[@chinmayeepanigrahi8428]

Your video is very informative, i wan to create a flow . the requirement is i have a application list with different roles as Delivery Leader, Delivery Manager, PM. I have another list as Member List. i want to create an automate flow which will on create or update of any of the above mentioned fields it should automatically check in the Member list if the person is not available in the Member list with the specified role then it should create a record in the member list( The fields in member list are User , ROle) e.g if a new PM added as person EMail [e-mail] then in memberlist a record should be added as user = [e-mail] and Role = PM. Please help.