Update a row for 2 key columns not just 1

[SteTaylor]

Hi All, 

I'm wanting to set up an automatic flow that runs off a form, updating a row if the submission time's date (or just today's date if that's easier) matches a date already in the table and the user submitting matches an email already in the table.  How do I set it up to have those 2 key columns rather than just 1?

Thansk in advance.

[v-LilyW-msft]

Hi @SteTaylor 

Thank you for posting.

According to your description, you want to filter a row that satisfies 2 key columns.

You can use Condition action and add multiple conditions.

I created a simple Flow, you can refer to:

This is my Form

This is my Excel

Flow in details:

The first condition to determine whether the submission date is equal to the date in excel

Expression1：formatDateTime(outputs('Get_response_details')?['body/submitDate'],'yyyy-MM-dd')

Expression2：formatDateTime(addDays('1899-12-30',int(items('Apply_to_each')?['date'])),'yyyy-MM-dd')

The second condition determine whether the response email is equal to the email in excel

If these two conditions are true, then update the row.

When Test2 who email is Test2@Wicren.onmicrosoft.com submit a From. The row will be updated.

Hope the content above may help you.

Best Regards

Lily

[SteTaylor]

Thanks for the speedy response @v-LilyW-msft , however I get this error when I try to run it:

Unable to process template language expressions for action 'Condition_3' at line '1' and column '38591': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Here's what the flow looks like - all thats missing is the when response submitted, get response details part at the top. 

The form has 2 options In or Out. In just populates a new row. Out needs to find a row where the In (called Time1) matches the submission date as well as the email matching on the key column so it can then update that row, giving me the in and out times side by side for further analysis. 

[v-LilyW-msft]

Hi @SteTaylor 

What is your date format in excel? Could you share the screenshot of your excel with me?

This is my date format.

The date need match ISO 8601 format in Flow.

For more info about ISO 8601 you can refer to:

https://en.wikipedia.org/wiki/ISO_8601

Best Regards

[SteTaylor]

It's set to Date and its how the flow has already populated it in there from its first run

 @v-LilyW-msft 

[v-LilyW-msft · Accepted solution]

Hi @SteTaylor 

Because your date format has time, so please change the expression as below and try again:

AddSeconds('1899-12-30',int(formatNumber(mul(float(items('Apply_to_each')?['Time1']),86400),'0')),'yyyy-MM-dd')

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.