Unanswered

How to remove a field in a row after a period of time?

(1) Share

Report

Posted on by patty2904

I'm building a flow that will remove an entry in a row after 6 months. I want the below 4 fields to be blank after 6 months, essentially. They are part of a row with more fields.:

This is what my current flow looks like:

With compose having the formula:

addDays(utcNow(), 180)

Filter array having:

From body/value

Filter Query: Last Strike Date is less than

addDays(utcNow(), -180)

Apply to each has: body/value

And in update row, I am doing:

I have tried a few variations, and they're all failing. Can anyone spot anything?

All responses (4)

Answers (0)

patty2904 14 on at

Like (1)

Report

How to remove a field in a row after a period of time?

Hi @ManishSolanki

I think I'm getting close to the solution. I'm getting the error: Action 'Update_a_row' failed: The 'inputs.parameters' of workflow operation 'Update_a_row' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'id' - 1

This is what my table looks like:
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report

Re: How to remove a field in a row after a period of time?

Hi,

Pls pass body of filter array:

when you hover mouse, it should look like: body('Filter_array')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
patty2904 14 on at

Like (1)

Report

Re: How to remove a field in a row after a period of time?

Thank you for your reply!

I think there's still an issue with my apply to each.

Unable to process template language expressions for action 'Apply_to_each' at line '0' and column '0': 'The template language expression 'outputs('Filter_array')['body/value']' cannot be evaluated because property 'body/value' doesn't exist, available properties are 'body'. Please see https://aka.ms/logicexpressions for usage details.'.

Which of the below should I be using?
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report
Re: How to remove a field in a row after a period of time?

Hi @patty2904

Assuming 'Last Strike Date' is the unique column in excel file to update record in it.

You need to select the 'key column' as 'Last Strike Date' and add an expression in 'key value' parameter. Expression needs to be added in the function box as shown below:

items('Apply_to_each')?['Last Strike Date']

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.