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?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
patty2904 14 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
patty2904 14 on at

Like (1)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No