Share
ReportTried it but i can't seem to get the condition syntax right
Here is a screenshot
You’re offline. This is a read only version of the page.
13
Tried it but i can't seem to get the condition syntax right
Here is a screenshot
Thanks this helped me solve my issue!
If there is nothing much happening after a conditional split please consider using error handling capability of Microsoft Flow along with Termination action with "Succeeded" status.
Example ("update a row" may be also "get row"):
Hi @majdi_d,
Could you please show a bit more about your Excel table?
Faurther, do you create a record in Opportunities object of Salesforce?
I think there is something wrong with the formula that you provided within Condition box. The formula that you provided is only supported in PowerApps ranther than Microsoft Flow. More details about expression supported in Microsoft Flow, please check the following article:
WDL expression in Microsoft Flow
In addition, I think you have a misunderstanding in usage of the "Get row" action of Excel connector. The "Get row" action of Excel connector is used to retrieve a single row from an Excel table, the Row id field of this action is required to fill a Unique identifier of a row in your Excel table ranther than the unique identifier of a record in your Salesforce object.
I assume that you created a record in Opportunity object of Salesforce, I have created a Excel table on my side and the data structure of it as below:
Note: The Opportunity ID column is used to store the unique identifier of a record in Opportunity Object.
I have made a test on my side and please take a try with the following workaround:
Note: If you want to check if there is a record with same Opportunity Name (or other properties) has been existed in your Excel table, within above Condition box, left input box set to Opportunity Name (or other properties) dynamic content.
All responses (
Answers (
@empty(body('Filter_array'))
Image reference:
The flow works successfully as below:
More details about using expression in flow actions, please check the following article:
Using Expression in flow actions
Best regards,
Kris
Ah, this is a PowerApps community board, you're using Microsoft Flow. I'll move this thread to the appropriate board, and someone there should be able to answer it.
