January Problem Solver of the MonthCongratulations to Sourav Dam for be selected in our monthly random drawing, Dynamics Community Problem Solver Sweepstakes.
Read aboug Sourav | Learn how to enter
2020 release wave 1 Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Hi Knowledgeable people!
Im thinking on create some records from excel file using MS-Flow, but i'm not sure about if it is possible to get dynamically its content...
The scenario is when a file is created in an specific sharepoint folder, run a flow that have to do the following, Read the file, get the rows, allows me to validate if for example the email address is on CRM as a contact, then create a new opportunity record and add that retrieved contact as opportunity contact... easy in the explanation, but im trying to do it on MS-Flow, but i'm not sure about how to get the rows/Columns to map the creation of the opportunity, as you will understand im getting the file dynamically, so i'm not getting the columns of the file, but im getting the table name...
any suggestion, guidance and friendly hand will be very appreciated.
Use the following:
"Get Rows" - Gives you Columns and Row ID
"Tables" - Gives you table details
Hi ba365guy! thanks for your comment.
Look, im using it, but since it is a dynamic file it doesnt retrieves me the columns as i need, the get table retrieves me the json objects, but how should i get the columns from it?
I cant use get rows, because is asking me for a Key Value, i defined a variable with the name of the column that i would use as Key (for example variable KeyColumn = ContactEmail), but its value works only when i use a manual input value like an email address, im not able to set something like if KeyColumn is not null then get rows...
Here the getting rows loop
i cant or don't know how to tell it "hey go to the table and check if the KeyColumn is not null and get rows".
Business Applications communities