Skip to main content

Notifications

Community site session details

Community site session details

Session Id : +YdWBeT8LHcme8+qrQHnZz
Power Automate - Building Flows
Answered

Update Sharepoint list item if excel show a particular value

Like (0) ShareShare
ReportReport
Posted on 17 Apr 2024 03:08:24 by 19

Hi Community!
I have an excel table and a Sharepoint list. I want to update Sharepoint list if a column of excel show a particular value.

For example: 

The excel table is like:

Employee IDNeed to update Sharepoint list item...
001Yes...
002Yes...
003No...

The Sharepoint list is like:

Employee IDColumn 1Column 2...
001SuccessfulPending...
002SuccessfulPending...
003  ...

If "Need to update Sharepoint list item" value of each record is equal to "Yes", update the correspondent employee id sharepoint list Column 1 to Successful, Column 2 to Pending. Since the trigger is recurrence (do at 10 am every workday), so need to check if the Sharepoint list items have updated before.

This is the flow I've created. 

[Condition] is Employee ID in excel is equal to Employee ID in Sharepoint list.

[Condition 2] is Column 1 in Sharepoint list is equal to empty.

But I found that the [Condition] are always false in Condition, so the following actions skipped. How do I modify the current flow?

Capture.PNG

Condition:

Capture2.PNG

  • Verified answer
    v-yetonggu-msft Profile Picture
    on 17 Apr 2024 at 04:31:56
    Re: Update Sharepoint list item if excel show a particular value

    Hi @etham_meng ,

    My Excel Table:

    vyetonggumsft_4-1713327557164.png

    My SharePoint List:

    vyetonggumsft_6-1713327774260.png

    1)I recommend that you recreate the flow and go to the classic designer to avoid unnecessary loops.

    My Flow Run History:

    vyetonggumsft_0-1713327289935.png

    2)I observed that the column names in your SharePoint list all contain spaces, this time the display name of the column is not the same as the internal name, we need to use the internal name of the column in the OData Filter of Get items, here are the steps to view the internal name of the column.

    vyetonggumsft_7-1713328100465.png

    vyetonggumsft_8-1713328138356.png

    vyetonggumsft_9-1713328205257.png

    My Flow Configuration Parameter:

    vyetonggumsft_1-1713327304461.png

    vyetonggumsft_2-1713327464376.png

     

    InternalName eq '@{items('Apply_to_each')?['Employee ID']}' and InternalName eq null
    length(outputs('Get_items')?['body/value'])

    When you use the expression I provided, please replace the 'InternalName' with the internal name of your own column, as we don't have the same internal name.

     

    vyetonggumsft_3-1713327520729.png

    Best Regards,

    Sunshine Gu

  • etham_meng Profile Picture
    19 on 17 Apr 2024 at 03:28:20
    Re: Update Sharepoint list item if excel show a particular value

    You could ignore List row present in email list, I forgot to delete.

  • v-yetonggu-msft Profile Picture
    on 17 Apr 2024 at 03:26:53
    Re: Update Sharepoint list item if excel show a particular value

    Hi @etham_meng ,

    vyetonggumsft_1-1713324174895.png

    Why did you add two list rows present in a table?

    What do these two identical actions do?

     

    Best Regards,

    Sunshine Gu

     

  • ManishSolanki Profile Picture
    15,085 Super User 2025 Season 1 on 17 Apr 2024 at 03:23:45
    Re: Update Sharepoint list item if excel show a particular value

    Hi @etham_meng 

     

    I would suggest using "Filter array" action instead of nested loop. Iterate SharePoint items in a loop and then use filter array action for each item to filter emp id from the output value object of "List rows present in a table". To check if row exists, use an expression and apply length() function to calculate the length of output array returns by filter array action.

     

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard
Loading started