cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DrishM13
Helper II
Helper II

Flow condition not working

Hi,

 

I have a flow that should send an email when column A in SharePoint is equal to 51 days. There are multiple documents that have different values for column A but I only want an email when it is equal to 51. So if yes, email sent.

 

As below:

 

DrishM13_0-1621320573890.png

 

It seems though that I am getting an email for all documents though and not just the one that has 51 in Column A.

 

Not sure why?

 

Thanks.

 

8 REPLIES 8
Achavan
Resolver II
Resolver II

hi @DrishM13 ,

just type 51 in equal to 

Achavan_0-1621321133786.png

If this helps you, please mark as solution.

DrishM13
Helper II
Helper II

Hi @Achavan , if I do that, I get the following error:

 

Which makes no sense as the expression should be true as there is an item on SharePoint that has 51 in Column A

DrishM13_0-1621324999343.png

 

did you try with int(51) ?

DrishM13
Helper II
Helper II

Hi @Achavan , still same error.

 

I am attaching my flow itself - not sure if a previous step is in the wrong?

 

DrishM13_0-1621328686094.png

 

 

DrishM13_1-1621328707120.png

 

can you please run your flow and show output of get files (properties) step ?

also try below expression 

 

Achavan_1-1621329028094.png

 

Still error with that expression

can you please run your flow and show output of get files (properties) step ?

DrishM13
Helper II
Helper II

{"statusCode":200,"headers":{"Transfer-Encoding":"chunked","Vary":"Origin,Accept-Encoding","X-SharePointHealthScore":"3","X-MS-SPConnector":"1","X-SP-SERVERSTATE":"ReadOnly=0","DATASERVICEVERSION":"3.0","SPClientServiceRequestDuration":"58","SPRequestGuid":"95d68c4d-1997-4cba-abeb-cb1f4bf0be97","request-id":"95d68c4d-1997-4cba-abeb-cb1f4bf0be97","MS-CV":"TYzWlZcZukyr68sfS/C+lw.0","Strict-Transport-Security":"max-age=31536000","X-FRAME-OPTIONS":"SAMEORIGIN","Content-Security-Policy":"frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com;","MicrosoftSharePointTeamServices":"16.0.0.21305","X-Content-Type-Options":"nosniff","X-MS-InvokeApp":"1; RequireReadOnly","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","Cache-Control":"max-age=0, private","Date":"Tue, 18 May 2021 10:30:39 GMT","P3P":"CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"","X-AspNet-Version":"4.0.30319","X-Powered-By":"ASP.NET","Content-Type":"application/json; charset=utf-8","Expires":"Mon, 03 May 2021 10:30:39 GMT","Last-Modified":"Tue, 18 May 2021 10:30:39 GMT","Content-Length":"12166"},"body":{"value":[{"@odata.etag":"\"1599\"","ItemInternalId":"1","ID":1,"ContractReferenceNumber":"AAA123","NameofCompanyEntityorEntities":"Entity 1","NameofOtherEntities":"Entity 2","DescriptionofContracts":"Test Purposes","ContractExpiryDate":"2021-07-08","Days_x0020_Until_x0020_Expiry":"51.0000000000000","Editor":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|email","DisplayName":"Name","Email":"Email","Picture":"site name/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Email","Department":"Technology","JobTitle":"Digital Systems Administrator"},"Editor#Claims":"i:0#.f|membership|email","TodaysDate":"2021-05-18","Created":"2021-05-17T07:25:15Z","Author":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|email","DisplayName":"Name","Email":"Email","Picture":"site name/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Email","Department":"Technology","JobTitle":"Digital Systems Administrator"},"Author#Claims":"i:0#.f|membership|email","Modified":"2021-05-18T10:30:02Z","OData__DisplayName":"","{Identifier}":"Contracts%252fTest.docx","{IsFolder}":false,"{Thumbnail}":{"Large":"https://northeurope1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=docx&cs=fFNQTw&docid... name/Contracts/Test.docx?d=wa219edd413814d30b8771029a5346ec6","{Name}":"Test","{FilenameWithExtension}":"Test.docx","{Path}":"Contracts/","{FullPath}":"Contracts/Test.docx","{IsCheckedOut}":false,"{VersionNumber}":"1599.0"},{"@odata.etag":"\"1594\"","ItemInternalId":"2","ID":2,"ContractReferenceNumber":"BBB5656","NameofCompanyEntityorEntities":"Entity 2","NameofOtherEntities":"Entity 3","DescriptionofContracts":"Test","ContractExpiryDate":"2021-05-25","Days_x0020_Until_x0020_Expiry":"7.00000000000000","Editor":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|email","DisplayName":"Name","Email":"Email","Picture":"site name/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Email","Department":"Technology","JobTitle":"Digital Systems Administrator"},"Editor#Claims":"i:0#.f|membership|email","TodaysDate":"2021-05-18","Created":"2021-05-17T07:54:03Z","Author":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|email","DisplayName":"Name","Email":"Email","Picture":"site name/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Email","Department":"Technology","JobTitle":"Digital Systems Administrator"},"Author#Claims":"i:0#.f|membership|email","Modified":"2021-05-18T10:30:03Z","OData__DisplayName":"","{Identifier}":"Contracts%252fTest%2b-%2bCopy.docx","{IsFolder}":false,"{Thumbnail}":{"Large":"https://northeurope1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=docx&cs=fFNQTw&docid... name/Contracts/Test%20-%20Copy.docx?d=w6494a18ecf514561abb11525e1f6a856","{Name}":"Test - Copy","{FilenameWithExtension}":"Test - Copy.docx","{Path}":"Contracts/","{FullPath}":"Contracts/Test - Copy.docx","{IsCheckedOut}":false,"{VersionNumber}":"1594.0"}]}}

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,915)