[Lists] Updating a column's content from another List when adding an entry

[Eawyne]

I've been toying around with Lists as my boss tasked me to update our data input from Excel. Lists is cleaner-looking and more corporate. I can get behind that.

Thing is, in my Excel file, I used macros extensively, but one key element was to check in other sheets when data was entered, and if there's a match, a message can be displayed, or it goes to open a local file.

It appears that there's a "lookup" option to check in another list, but so far, I still need to manually pick the match in a list - and I can't have it open my file if needed. It appears I'll need Power Apps - and the users will all be on PC - there might be an upgrade to phones in an unforeseeable future.

To be fair, I'm having trouble getting into those new tools - learning VBA is still a thing ! I might have the wrong approach, but I really can't seem to find resources to help figure out to properly use them. Would anyone have some suggestions on how to pull this up ? And as a secondary question, would anyone have some noob-friendly tutorials and guides ? What I've found never seems to properly fit what I'm looking for.

 

[JEC]

In Power Apps, the syntax is a little bit different then Excel, but it is pretty easy to get your hands on.
Before you enter the data, you can indeed do a lookup in your current list, to check for existing records.

This is a simple example to lookup a record to get you started

if(isempty(lookup(yourlist, Department= "sales" && Age > 24)), Notify("Record already exists"), do stuff if false)

 

[Eawyne]

Hey, sorry for the late response, but it's been a hectic month !

I'm not too used to Excel's syntax, but I recognize what it's doing indeed ^^ However, I have no clue what to do with this now...