speeddownloadpie.blogg.se

I get an error saying the schema validation failed because it saw an object and expected an array. Hmm, so I followed your steps and my flow fails on the parse json step.

Go back and edit the flow and create up to the Parse JSON action.Ħ.

In the "List Rows Present in table", click the downlod link in the outputsĥ. WIth the above flow, just create up to the Excel "List Rows present in table".ģ. To get the JSON Schema you can do the following:ġ. I ran through on a dummy spreadsheet and got these results (I set it up so taht I would only get 2 results, one with a 30 and with a 120 date). Now loop through the array and send an email.I am using a Compose statement instead just to show you the results. Next, Parse the JSON so we can grab out individual fields later.Ĥ. The filter here looks really complex but its just 3 repeated statments checking if the expiry date is equal to todays date + 30, +60 and string(add(outputs('Compose_-_Today_in_Integer'), 30))),equals(item()?, string(add(outputs('Compose_-_Today_in_Integer'), 60))),equals(item()?, string(add(outputs('Compose_-_Today_in_Integer'), 120))))ģ. Get the rows form Excel, and then filter out only those rows that will expire in 30, 60 and 120 days. This formula converts the Time Zone converted date to Integer Date in my Compose Statement:ĭiv(sub(ticks(formatDateTime(body('Convert_time_zone'), 'yyyy-MM-ddT00:00:00')), 599264352000000000), 864000000000)Ģ. I convert todays date to integer date, so I can compare this with what comes out of Excel.

I also converted utcNow to my timezone, but you can just use utcNow if you want to.ġ.

I use the Parse JSON action, I'll show you also how I got the schema after the solution.

I used integer date since I was going to just check 30, 60 and120 but you may want to instead of doing what I did and adjust your formula's appropriately. You can convert to date by the following:ĪddDays('', int(), 'dd-MM-yyyy')

Excel dates when they get brought across into Power Automate get converted to integer.

I've put something together, but there probably is a much simpler way, but this should uple of notes: