Hi All,
Flow Details: I am having a flow that gets the data from email and create a item in SPO List. And the column names are Record Number, City, Country and so on. I was getting multiple emails for one record number and at that time the flow need to check If the record number is existing or not in the SPO list.
Actions:
Any suggestions on the condition part..
Thank you.
Solved! Go to Solution.
Hope this help 🙂
For the record number, you should check that the SP list ensures that there are no duplicate Record numbers:
It probably needs to be a required field too:
Filter query can be used to Get Items (uses oData filters to construct the query):
Use a condition to check to see if any records are returned:
If length(outputs('Get_items')?['body/value']) is greater 0 - that means a record was returned by the filter:
Note that even though only one record is returned, Get Items returns an array, which Power Automate will need to cycle through, hence the use of Apply to each loop.
Hope this help 🙂
For the record number, you should check that the SP list ensures that there are no duplicate Record numbers:
It probably needs to be a required field too:
Filter query can be used to Get Items (uses oData filters to construct the query):
Use a condition to check to see if any records are returned:
If length(outputs('Get_items')?['body/value']) is greater 0 - that means a record was returned by the filter:
Note that even though only one record is returned, Get Items returns an array, which Power Automate will need to cycle through, hence the use of Apply to each loop.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
73 | |
26 | |
20 | |
15 | |
15 |
User | Count |
---|---|
144 | |
44 | |
44 | |
34 | |
31 |