You have two possible options: use a List Rows Present in a Table and filter it by day, or use some text transformation expressions to convert your date into serial number before using it in Get row. Let's see these 2 options in practice.
I'm working with this sample table:
Then in PA I have the same formula as you, but allocated in a Filter query, where column date must match to your addDays:
For this approach, make sure to set the DateTime Format property to ISO 8601 (highlighted in yellow above), since Excel return dates in Serial format by default.
The other option is to keep working with Get a row, but transforming your date into a serial format before adding it as key value (we use the expression from Compose for it). For this approach, make sure to set the DateTime Format property to Serial Number:
The full expression is: first(split(dateDifference('1899-12-30', startOfDay(addDays(utcNow(), -1))), '.')), where your original expression is allocated in the inner layer, and it basically gets the date difference between your date and Dec 30, 1899, and isolate the days qty from it. Depending on your timezone, you will need to adjust the default date for comparing the difference to '1899-12-31': I'm at EST and Dec 30 works better.
I'm also sharing some articles related to the topics discussed here for further reference:
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.
