Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

How to get Power Automate to check if an item exists in a SharePoint list and then update the listing accordingly ?

(1) ShareShare
ReportReport
Posted on by

 

Hi does anyone know how to tell Power Automate to check if an item exists in a SharePoint list and then update the remaining columns of the list accordingly?

 

I have a SharePoint list where it will record all the responses of users' training details via MS Form:

Date of form submission

Participant Name 

Course Name 

Course Provider

Course Address

Approval Status

etc 

etc

Post Course Achievement

 

Flow in brief:

  • Form sent,
  • approval sent,
  • approve,
  • details recorded in sharepoint,
  • after training end date to send for email reminder to participant to input post course achievement where a separate form link is stated in the email reminder
  • Participant then send responded in the post training form.
 
 

2024-07-10_Array-Filter Error.JPG

 

memento_0-1720596363788.png

It seems that the flow is looking for Column "Course222" but i am checking for the data "Course222" in column "Course Name".

 

Everything works until the point on the identification part. How to link the post response to the initial response so that the post course achievement can be updated? 

 

I have already tried to connect the post response course name = initial response course name and 

post response name = initial response name

2024-07-10 Details.JPG

so that this can be the unique identifier to match.

 

But seems like it doesn't work.

 

Please advise. Thanks !

 

 

 

  • memento Profile Picture
    memento on at
    Re: How to get Power Automate to check if an item exists in a SharePoint list and then update the listing accordingly ?

    Hi @FLMike 

    Yes error at Get items 

    memento_0-1720667192334.png

     

  • FLMike Profile Picture
    FLMike 29,105 on at
    Re: How to get Power Automate to check if an item exists in a SharePoint list and then update the listing accordingly ?

    The Get Items or the flow?

     

    Can you share what the flow was doing? in the Run.

  • memento Profile Picture
    memento on at
    Re: How to get Power Automate to check if an item exists in a SharePoint list and then update the listing accordingly ?

    Hi @FLMike 

     

    not sure why it kept spinning :

     

    memento_0-1720666322918.png

     

  • FLMike Profile Picture
    FLMike 29,105 on at
    Re: How to get Power Automate to check if an item exists in a SharePoint list and then update the listing accordingly ?

    Also btw, might have just been a typo, but in your description you mentioned Full Name as the column, nut in the query you just wrote Name

     

    Just in case thats another possible issue

  • FLMike Profile Picture
    FLMike 29,105 on at
    Re: How to get Power Automate to check if an item exists in a SharePoint list and then update the listing accordingly ?

    Hi @memento 

     

    Super close. If you have spaces in the column name you have to wrap it in brackets, just like a Column in SQL Server with spaces

     

    [Course Programme] eq 'CourseABC' and Name eq ''

     

    Cheers


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • memento Profile Picture
    memento on at
    Re: How to get Power Automate to check if an item exists in a SharePoint list and then update the listing accordingly ?

    Hi @FLMike 

     

    Ok is this what you meant?

     

    Course Programme is the column name 

    Full Name is the column name 

     

    and i am asking the flow to:

    1. find in the column Course Programme if there is any Course Name that is responded from the post training form

    (for example if Course Programme is 'CourseABC' and it is the same in the post training form, then it will match the row)

    and

    2. find in the column Full Name if there is any Full Name that is responded from the post training form

    (for example if Full name is 'ABC' and it is the same in the post training form, then it will match the row)

     

    memento_1-1720658853817.png

     

    Because it needs to be dynamic since there will be multiple participants with different post course achievements.

    so if CourseABC + NameABC, update his post course achievement stated in the post form in the Sharepoint List.

     

    if Course123 + Name123, update his post course achievement stated in the post form in the Sharepoint List.

     

    (Note: The Course Programme and Full Name already existed in the Sharepoint List previously when participant submitted the first form for approval.)

     

    But error occurred:

    memento_0-1720658834920.png

    Or is there a better way of doing this? 

  • FLMike Profile Picture
    FLMike 29,105 on at
    Re: How to get Power Automate to check if an item exists in a SharePoint list and then update the listing accordingly ?

    Hi @memento 

     

    Actually you aren't. You put in a Dynamic Property in your Filter, which will make it use a Value, not the Column name

     

    Change your filter to be

     

    ColumnName eq 'Value'

    Not Dynamic Proeprty eq 'Dynamic Property'

     

    Make sure that you use the Correct Name for the column. If you are unsure of its Name (not its label)

    1. Go to the list

    2. Click the Settings Cog and go to List settings

    3. Click on the Column in thelist

    4. Look at the URL and at the end will be the correct name for the column

     

    Use that in your filter, NOT what you have

    Change both of your Column Names and you should be good


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard