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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,309)