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

[blpraveena]

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

[Kaif_Siddique · Accepted solution]

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:

Get Item from PDF COMPAER2:

Compare both lists:

Sample PDF COMPAER2 list:

Sample PDF COMPAER list:

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]

Hello ,

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

can help me solve this

[Kaif_Siddique]

could you share new/sample text?

[blpraveena]

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]

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]

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]

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]

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.

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.