Answered

Flow to mirror SharePoint list in a data verse table ahead of full migration

(0) Share

Report

Posted on by HBMWP

Hi,

I have a PowerApps that runs on SharePoint. I am currently building an alternative app, which runs on Data verse. I have already migrated the data from SharePoint to data verse. I did this through a csv import.

My flow works when a new item is created, but I am struggling with when the item is updated.

I get the following error for when it runs on the 'no', when modified, branch -

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Manish Solanki 15,099 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @HBMWP

Pls select unique identifier for each entity instance and pass it to row id parameter as shown below:

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
HBMWP 11 on at

Like (0)

Report
Copy link

Link copied!

@ManishSolanki Thanks for replying.

The flow is going through, but it is creating a new row each time, not updating.

The primary name is the sharpeoint ID, so you can see it creating not updating here :

Was this reply helpful? Yes No
Manish Solanki 15,099 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @HBMWP

Have you added "Add row" action in the "Yes" block? In that case, I think the condition always evaluates to true which creates a new row in the table and flow never executes the "No" block to update row in table. You can verify this by checking the flow run history.

I think condition for comparing created & modified date is not reliable, so we need to find an alternative.

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
HBMWP 11 on at

Like (0)

Report
Copy link

Link copied!

@ManishSolanki thanks for getting back to me.

Yes, and I think the problem is that I normally edit on the same day that I create. The app, which is built on the SP list, checks/adds to data entry from AI Builder.

This is the rest of the flow.

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,099 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @HBMWP

To compare only date part of the dates, we can use expression with formatDateTime() function. You need to write an expression for both created & modified column or field in condition action as shown below:

Expression used for created (left side):

formatDateTime(triggerOutputs()?['body/Created'],'yyyy-MM-dd')

Expression used for modified (right side):

formatDateTime(triggerOutputs()?['body/Modified'],'yyyy-MM-dd')

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