Hi there I am buliding a flow to automate the following procedure:
when a event is created in outlook and a rescource is booked. its generate a element in a SharePoint list called "Forplejning - Test" contaning the subject, start time from the event - and some custom columns.
And the element is created like this:
My question is then. How do i get the values from the table below (Kildevand: 10 & sodavand: 20) in my flow, and into my list (in the custom columns called: Kildevand and Sodavand)?
Thank you very much! 😉
Do you want to extract Antal value of each Vare and save them back to SharePoint list?
Please take the following configuration for a reference.
Add a trigger When a new event is created.
Add the action HTML to text to convert the body to text.
Add compose2 use the following code to get the starting position of Kidevand:
Add Compose3 to get the starting position of Antal value of each vare:
Add Compose4, get starting position of Sodavand:
Add Compose5, get Antal value of Kidevand:
Add Compose6 to return Antal value of Sodavand:
Hope it could be your reference.
Thank you very much for your reply! actually last night I managed to use the following code and get the values right:
substring(body('Html_to_text'),add(lastIndexOf(body('Html_to_text'),'Kildevand: '), XX),X)
Thanks for updating.
I am glad to hear that you have figured out a solution.
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!