I am in the process of creating a flow that will take a list and export it as a selectable list. that the email recipient will select one of the vehicles and then click an approve button that will start the next step of the flow. I am using the help provide in this message https://powerusers.microsoft.com/t5/Building-Flows/Get-Items-from-SharePoint-list-compose-email-body....
My current flow looks like this
I was getting an error
It was being created by this
I removed this and put this
This is what I am getting in email and it does this for each vehicle and it does it eight times all in one email
My Goal is to get this data sent back to me in a table with just the vehicle numbers and vehicle names where I will click one vehicle and then hit an approve button that will update my list and continue the process.
All comments will be greatly appreciated.
Solved! Go to Solution.
Hi @ ikgray,
What is the configuration of your sharepoint list?
Do you mean want to select on option in the email and then click an button to approve?
Click an button to approve is not supported in Microsoft flow currently, you could refer to workaround below to achieve your needs.
I have made a test on my side, and have created a sharepoint list as below:
The “Vehicle Name” and “Vehicle Number” column all Single line of text type column.
The “BeSelected” column is a “Yes/No” type column, the column would be updated when an option is made in the received email.
You could create a flow as screenshots below to achieve your needs:
Note:
concat(body('Get_item')?['Vevicle_x0020_Number'],' - ',body('Get_item')?['Vehicle_x0020_Name'],',')
7. Choose the “Output” dynamic content of the “Compose” in the “Value” field of the “Append to string variable” action.
8. Add action “Send email with options ” outside the “Apply to each”, choose the “options” dynamic content of the “Compose” in the “User Options” field. Choose the “Output” dynamic content of the “Create HTML table” action in the “Body” field.
9. Add a Condition under the “Send email with options ”,you could choose the “SelectedOption” dynamic content of the “Send email with options” as the first value, and you could fill in the second value and the condition in the middle to realize your needs and update the item.
When an item which’s Vehicle Name is “2020 Ford Expedition” is created in the list, the flow would run successfully to send an email with options as below:
The email with options would arrived as below:
When you choose an option in the email, if the option you choose is “1 – 2015 Ford Expedition“,the rest flow would run successfully as below:
Regards,
Alice Zhang
Follow up, I have been working with this and using different ways to bring the data into an outlook email
I've gone from geting a text list being repeated eight times (number of vehicles) to eight emails each with a diffrent vehicle in each.
This is actuall what I am try to get but it will be all eight vehicles (I'll add filters later), in one email!
Hi @ ikgray,
What is the configuration of your sharepoint list?
Do you mean want to select on option in the email and then click an button to approve?
Click an button to approve is not supported in Microsoft flow currently, you could refer to workaround below to achieve your needs.
I have made a test on my side, and have created a sharepoint list as below:
The “Vehicle Name” and “Vehicle Number” column all Single line of text type column.
The “BeSelected” column is a “Yes/No” type column, the column would be updated when an option is made in the received email.
You could create a flow as screenshots below to achieve your needs:
Note:
concat(body('Get_item')?['Vevicle_x0020_Number'],' - ',body('Get_item')?['Vehicle_x0020_Name'],',')
7. Choose the “Output” dynamic content of the “Compose” in the “Value” field of the “Append to string variable” action.
8. Add action “Send email with options ” outside the “Apply to each”, choose the “options” dynamic content of the “Compose” in the “User Options” field. Choose the “Output” dynamic content of the “Create HTML table” action in the “Body” field.
9. Add a Condition under the “Send email with options ”,you could choose the “SelectedOption” dynamic content of the “Send email with options” as the first value, and you could fill in the second value and the condition in the middle to realize your needs and update the item.
When an item which’s Vehicle Name is “2020 Ford Expedition” is created in the list, the flow would run successfully to send an email with options as below:
The email with options would arrived as below:
When you choose an option in the email, if the option you choose is “1 – 2015 Ford Expedition“,the rest flow would run successfully as below:
Regards,
Alice Zhang
Hi
In my scenario,
I am writing code for print form option.
Step1: I wrote a HTML code for my application
Step2: I used this code on MS FLow
Step3: after creating the flow. I was calling flow from powerapps
step4: Now i was able to get data into the html with flow
On my powerapps, based on dropdown select all the other feilds will populate, I'm unable to hide feilds based on dropdown selected value on HTMl.
is there any way to hide labels based on selected value on HTML
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
25 | |
24 | |
23 | |
23 | |
17 |
User | Count |
---|---|
56 | |
39 | |
37 | |
30 | |
28 |