Answered

Compare Excel table to SharePoint List then update rows that have not be modified(checked) in the SharePoint List

(0) Share

Report

Posted on by flexcodec

Hello

please i have to update my SharePoint data with the data that are coming from an excel file created with my flow. but during the update, the flow must just update data that have not been checked in the share point (my share point checking status is directly created on SharePoint not on excel). so, my flow must just skip the row that have been checked and update those that are not. because the main objective is to keep the rows that have been checked for a futur use.

please any idea?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @flexcodec,

Do you want to update List items only not been checked?

If so, I think you need to use Get items action and filter on status that not been checked:

Was this reply helpful? Yes No
flexcodec 55 on at

Like (0)

Report
Copy link

Link copied!

yes that is what i want t do but not only that i want to update the value that have not been checked and also replace those that have been checked.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

HI @flexcodec,

Well, update the value that have not been checked, which is the main issue you mentioned in your topic...

And how to replace those that have been checked, is similar with the way how you update the value that have not been checked.

Was this reply helpful? Yes No