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,167 Moderator 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,167 Moderator 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,167 Moderator 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