web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / how to compare two sha...
Power Automate
Answered

how to compare two share point list values(TEXT) using Power Automate Flow

(0) ShareShare
ReportReport
Posted on by 45

hello All i have two share point lists in share point i have one row and two column and in second share point list also same one row 2 column are there so now i want to compare rows values (TEXT) are matching are not.

 

and in one share point list row will be keep updating weekly once, so at that  time also flow should compare updated row with the other  list  which have single row and give result as its matching or not.

 

Please Find Below Images For Your Refrence

blpraveena_0-1679411983454.png

 

blpraveena_1-1679411983920.png

 

blpraveena_2-1679411984133.png

 

 

  • Verified answer
    Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    Hi @blpraveena ,

     

    Kindly post your query in right category.

     

    Here is a sample flow. Customize it as per your requirements.

     

    Get Item from PDF COMPAER:

    Kaif_Siddique_0-1679426331518.png

     

    Get Item from PDF COMPAER2:

    Kaif_Siddique_1-1679426430374.png

     

    Compare both lists:

    Kaif_Siddique_2-1679426710814.png

     

    Sample PDF COMPAER2 list:

    Kaif_Siddique_3-1679426733036.png

     

    Sample PDF COMPAER list:

    Kaif_Siddique_4-1679426751443.png

    Hope this will help you.

     

    If I have answered your question, please mark my post as Solved.

    If you like my response, please give it a Thumbs Up.

     

    Regards

    Kaif

  • blpraveena Profile Picture
    45 on at

    Hello ,

    when i upload new text which matches reference text but result is coming its not matching.

    can help me solve this

  • Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    could you share new/sample text?

  • blpraveena Profile Picture
    45 on at

    1. ACCEPTANCE OF GOODS: The acceptance of goods is
    subject to our inspection after arrival of the goods at our works or at
    thesupplier#s works unless otherwise specified in the order. Our inspection
    shall include validation of parameters at a 3rd party where thein-house facility
    for validation is not available.2. RIGHTS: The Company, its customers and
    regulatory authorities reserves the right of access, inspect and audit to all
    facilities of thesupplier and records related to the product and also reserves
    right to verification of product requirements as per specification given by
    thecompany. The retention period of records related to product or process
    supplied should be 7 years or as defined by the customers.3. If no communication
    received from the supplier within 7 days from receipt of the Purchase Order, it
    is presumed that the order isaccepted.4. DELIVERY - Supplier shall make
    materials available to SANSERA within specified time. In the event supplier
    fails to deliver thematerials within specified time limit, the matter will be
    referred to the Unit head for further review.5. QUALITY - Response to customer
    complaints should within 2 working days and action plan should be submitted
    within 3 workingdays from receipt of the complaint. If any deviations in writing
    given by the Company for corrective actions same should be accepted
    forimplementing in the process.6. Please ensure that material reach us without
    any transit damage.7. The material supplied by you should satisfy the current
    Regulatory, Statutory Rules and Regulations.8. Any difference or dispute arising
    out of this Purchase Order shall be subject to Jurisdiction of Bangalore Courts
    only.10. In case of supply of Chemicals & Lubricants should be enclosed a copy
    of Material Safety Data Sheet (MSDS).11. In case the product supplied by you has
    a limited shelf life, please ensure that atleast Three (3) month shelf life is
    remaining as ondate of receipt at SANSERA. Please specify the date of
    manufacturing and date of expiry on each packing.12. Latest Revision to be
    followed for all the industrial specification and all the customer/proprietor
    standards to be followed as perSA-F-MR-03 Rev. 00. Master List / standard list
    shared by Sansera.In view of AS9100 Rev D, the following additional requirements
    of the standard are flown down here for adherence by all externalproduct and
    service providers to Sansera Engineering, Bangalore effective from 1 st December
    2017.Following are the two key requirements which Sansera expects all external
    product and service providers to note and take appropriateaction to meet the
    requirement of the standard AS 9100 D. Sansera also expects a confirmation from
    the respective entities to confirmadherence to the requirements of the standard.
    In the absence of a confirmation, it will be construed that the requiems are
    understood andimplemented by the respective external providers.Product
    Safety:Purpose: The purpose is to ensure that the integrity of the product is
    verified upon receipt and before dispatch to ensure that safety of theproduct is
    protected throughout its life cycle in the premises. In case of issues, the same
    shall be brought to the notice of the PurchaseHead at Sansera Engineering within
    12 hours of observation.* Implementation of suitable measures needed in
    controlling the processes to ensure product safety throughout its life cycle in
    therealization of products. That is to ensure that the product performs to its
    intended purpose without causing unacceptable Risk to thepersons, product and
    any damage to the property.* Assess probable hazards as a result of Process or
    equipment or any other and mitigate Risks in advance.* Assess probable safety
    hazards due to external issues which could affect product and personnel safety.
    Take suitable actions to mitigatethe probable Risks. Document actions taken.*
    Manage safety aspects and handle safety critical parts if any with appropriate
    controls put in place preventing a hazard materializing.* Take appropriate
    measure to protect the physical integrity of the product throughout its life
    cycle in the premises.* Take appropriate steps to prevent a safety hazard during
    handling, storage, packing, loading and unloading.* Maintain a Risk Register
    documenting all the actions taken. Display lessons learnt and communicate to all
    concerned down the line toensure effective communication.Prevention of
    Counterfeit parts :Purpose: The purpose of this requirement is to ensure that
    counterfeit parts do not flow into the supply chain and cause serious
    hazardslater. The term counterfeit part refers not only to the hardware product
    but covers the following;* All incoming materials including raw materials,
    consumables etc* Banking on Authentic and trusted source of purchase of all
    incoming materials.Page

     

    ABOVE IS THE TEXT

  • Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    As you mentioned above, new text matches reference text. So issue is not with reference text. Could you check the Title ?

     

    Also, share Title and Terms reference sample text from PDF COMPAER2 list and PDF COMPAER list. So that i can validate with my flow.

  • blpraveena Profile Picture
    45 on at

    hello ,

    thanks for your reply

    as u mentioned above i have checked the title as well and i am comparing only Terms reference.

    * next point is whatever i have sent you text, take that as reference as well new text. because i have created a flow to extract data from pdf (invoice) and update in share point list, so every time same data will extract. so it should match.

     

    * next point is if I copy the extracted data in share point and paste that in reference then again if i run the flow with same pdf it will match . but if i run the flow with different pdf its not matching, but text will be same as previous one. only difference is pdf (invoice) is different.

     

    * and in every pdf (invoice) text will be in one page only. so flow will extract text as same as previous one.

  • blpraveena Profile Picture
    45 on at

    1. ACCEPTANCE OF GOODS: The acceptance of goods is subject to
    our inspection after arrival of the goods at our works or at thesupplier#s works
    unless otherwise specified in the order. Our inspection shall include validation
    of parameters at a 3rd party where thein-house facility for validation is not
    available.2. RIGHTS: The Company, its customers and regulatory authorities
    reserves the right of access, inspect and audit to all facilities of thesupplier
    and records related to the product and also reserves right to verification of
    product requirements as per specification given by thecompany. The retention
    period of records related to product or process supplied should be 7 years or as
    defined by the customers.3. If no communication received from the supplier
    within 7 days from receipt of the Purchase Order, it is presumed that the order
    isaccepted.4. DELIVERY - Supplier shall make materials available to SANSERA
    within specified time. In the event supplier fails to deliver thematerials
    within specified time limit, the matter will be referred to the Unit head for
    further review.5. QUALITY - Response to customer complaints should within 2
    working days and action plan should be submitted within 3 workingdays from
    receipt of the complaint. If any deviations in writing given by the Company for
    corrective actions same should be accepted forimplementing in the process.6.
    Please ensure that material reach us without any transit damage.7. The material
    supplied by you should satisfy the current Regulatory, Statutory Rules and
    Regulations.8. Any difference or dispute arising out of this Purchase Order
    shall be subject to Jurisdiction of Bangalore Courts only.10. In case of supply
    of Chemicals & Lubricants should be enclosed a copy of Material Safety Data
    Sheet (MSDS).11. In case the product supplied by you has a limited shelf life,
    please ensure that atleast Three (3) month shelf life is remaining as ondate of
    receipt at SANSERA. Please specify the date of manufacturing and date of expiry
    on each packing.12. Latest Revision to be followed for all the industrial
    specification and all the customer/proprietor standards to be followed as
    perSA-F-MR-03 Rev. 00. Master List / standard list shared by Sansera.In view of
    AS9100 Rev D, the following additional requirements of the standard are flown
    down here for adherence by all externalproduct and service providers to Sansera
    Engineering, Bangalore effective from 1 st December 2017.Following are the two
    key requirements which Sansera expects all external product and service
    providers to note and take appropriateaction to meet the requirement of the
    standard AS 9100 D. Sansera also expects a confirmation from the respective
    entities to confirmadherence to the requirements of the standard. In the absence
    of a confirmation, it will be construed that the requiems are understood
    andimplemented by the respective external providers.Product Safety:Purpose: The
    purpose is to ensure that the integrity of the product is verified upon receipt
    and before dispatch to ensure that safety of theproduct is protected throughout
    its life cycle in the premises. In case of issues, the same shall be brought to
    the notice of the PurchaseHead at Sansera Engineering within 12 hours of
    observation.* Implementation of suitable measures needed in controlling the
    processes to ensure product safety throughout its life cycle in therealization
    of products. That is to ensure that the product performs to its intended purpose
    without causing unacceptable Risk to thepersons, product and any damage to the
    property.* Assess probable hazards as a result of Process or equipment or any
    other and mitigate Risks in advance.* Assess probable safety hazards due to
    external issues which could affect product and personnel safety. Take suitable
    actions to mitigatethe probable Risks. Document actions taken.* Manage safety
    aspects and handle safety critical parts if any with appropriate controls put in
    place preventing a hazard materializing.* Take appropriate measure to protect
    the physical integrity of the product throughout its life cycle in the
    premises.* Take appropriate steps to prevent a safety hazard during handling,
    storage, packing, loading and unloading.* Maintain a Risk Register documenting
    all the actions taken. Display lessons learnt and communicate to all concerned
    down the line toensure effective communication.Prevention of Counterfeit parts
    :Purpose: The purpose of this requirement is to ensure that counterfeit parts do
    not flow into the supply chain and cause serious hazardslater. The term
    counterfeit part refers not only to the hardware product but covers the
    following;* All incoming materials including raw materials, consumables etc*
    Banking on Authentic and trusted source of purchase of all incoming
    materials.Page

     

    look into above text it is extracted from another pdf but text is same some formats changes. please compare this with previous one text. like in first line you can see more words in this text than previous one.

  • Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    I think the issue is not with flow.

     

    I copied old text and new text into two different cells and compared it. Both are not equal.

    Kaif_Siddique_0-1680720335667.png

     

    Also, notice that Line Break(highlighted in yellow) does not have space in Old Text . That's why Old Text and New Text are not matching.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 273 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 235

#3
David_MA Profile Picture

David_MA 172 Super User 2026 Season 2

Last 30 days Overall leaderboard