search – Data row lookup in separate big data sheet and placing it inside another sheet in Google spreadsheet

I would like to make a Google spreadshit for calorie tracking. In my head I imagine it as I would like to have a sheet where I will record daily food activity. And another DB sheet with all time consumed food types with their parameters. So, the idea is when I type food name in daily diary sheet it will lookup in DB sheet if I already recorded this food macros and the food exists it just places reference to the existing food or copies its parameters. So, my question is it possible to implement something like spotlight? When I type some characters it displays kind of popup with suggestions based on DB sheet data and if I choose popup element it gives me a reference to that data. Ideally it would be great to have a fuzzy search. Maybe someone knows in which directions may I start to research or some impelemnted solutions?

sharepoint online – Getting 401 error when placing HTTP request in Flow

I’m trying to write a Flow that gets a list of emails from the Finance Managers list to send an email to. When I get to the HTTP Request to query the Finance Managers list, it throws a 401 error- access denied. The list I’m querying is of course on SharePoint Online (O365). Do I need to do something like creating an app step and authorizing the Flow like I had to do with SharePoint Designer workflows? If so, how do I do that with a Power Automate Flow?

database design – When placing an order in a shop, should a shapshop be taken of the products in an order also?

…to prevent messing up with data updates, such as prices, titles, of the products that are placed in an order.

Namely, a customer buys 3 items: for $5, $10 and $33 and pays for them. All is well. When I as an owner of a shop step in and, before I’ve delivered those products to a customer, decide to descrease the price of the product, say, #2. Its new price will be $8 instead of $10. And I’ll also rename the product #3 a little bit. A customer then would go to a status tracking page and they’ll see updated data. Yes, they’ve paid and the order is being delivered, but the data has already changed in the database. They’ll be consufed.

And so will be I in a year after I’ll have changed the prices again, renamed something, etc… and decide to view history of the orders for a year.

Question 1: is there a practise of making a snaphot of the current prices, names, total order price and other characteristics of the products that constitute an order, as well as other details (chosen shipping rate and shipping method, taxes, discounts, etc) at the moment when it’s being placed? Rather than calculating those dynamically when an “order page” is opened?

If yes, does it have a name? And are there recommendations of how to do it properly?

Question 2: where and how should I store a snaphot?

option #1:

I’d have to create multiple tables then:

that will have the same structure as their dynamics corresponding ones.

Laborious. Is there a better way?

option #2:

along with an order, in the “orders” table. But how again, given the fact that an order is a single row? For instance, the products in an order is a list. How would I store a list with its characteristics (price, weight, colour, material, what have you) in a row in such a way that’ll be more or less easy to retrieve in the future? Not as a string.

2d – Unity difficulty placing text within the canvas reference resolution

I have a TextMeshPro GameObject that I placed in the canvas. The canvas is set to Scale with Screen Size and has a reference resolution of 1440×1080.

The TextMeshPro GameObject is anchored at the top right and its horizontal position is -185 from the anchored point (top right). And it looks like this within a resolution of 1440 x 1080:

Enter the image description here

However, if I make my display resolution higher or smaller (such as 1920 x 1080 as in the image below), the TextMeshPro GameObject goes outside the game and ends up in the black area.

Enter the image description here

I tried to change the position of TextMeshPro GameObject using a script attached to the artboard. I came up with the following formula, but it seems to be wrong.

DisplayResolution.x - (DisplayResolution.X + (ReferenceResolution.X - TextMeshPro.Location.X))

Accepted:

DisplayResolution.X = 1920
ReferenceResolution.X = 1440
TextMeshPro.Location.X = -185

Edit – Reply to comments:

Where is Starry Backfield:

Enter the image description here

Camera settings:

Enter the image description here

Canvas settings:

Enter the image description here