User Profile
Kimberly_Huffman
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Microsoft Forms: Ranking question type calculation methodology
Kendra_Perry In the screenshot, you can see how the Forms ranked compared to using the RCV Universal Tabulator. I collected the votes using Forms, opened the results in Excel, and uploaded those results to the RCV tabulator. Hope this helps.15KViews1like1CommentRe: Microsoft Forms: Ranking question type calculation methodology
mrdlo Sure 🙂 I found a lot of great information and the tabulator at Ranked Choice Voting Resource Center. We used the Single-Winner RCV. I downloaded and installed the RCV Universal Tabulator. It worked great. The tabulator is actually stored in GitHub along with documentation. Good Luck! ~Kimberly23KViews1like3CommentsRe: Extracting custom fields from bookings
DashBois - we created 4 exchange accounts, each representing a staff being used in MS Bookings. I added the accounts to my Outlook account which then made them show up in the Calendar ID drop down. I have since removed those accounts from my Outlook and the flows are still working.16KViews0likes2CommentsRe: Custom Fields in Microsoft Bookings
ddmurrayjr When you click in the Value field of your variable, the dynamic content flyout should appear. Select the Expression tab and under the String functions, choose See More, then scroll down and you should see the trim(text) function. Let me know if you have any other questions.18KViews1like4CommentsRe: Custom Fields in Microsoft Bookings
ddmurrayjr Tell me about the staff accounts you have assigned to each service. It's those staff account calendars that Power Automate will tap into to capture the information. Because I don't know your exact situation I could be very wrong, but I don't think you need 6 different services, just 6 "staff" accounts. Let me explain our scenario and our setup. Our specific use is to allow employees to schedule vaccination appointments. We have 4 nursing stations providing vaccinations every 5 minutes. With our setup we can schedule 4 employees every 5 min We created 4 office accounts, 1 for each nursing station (Nurse1, Nurse2, etc.) These accounts have email addresses and outlook calendars. Make sure you get access to these accounts. We created a single Booking service (Vaccination) with a default duration of 5 min, max attendees 1, and custom fields. We assigned the 4 Nurse accounts as the assigned staff for the service. So I could access these account's calendars using Power Automate, I added the 4 accounts to my Outlook account by selecting Add Account on the Info page of Outlook. We created a Power Automate flow for each Nursing station account to capture the appointment details (I have 4 flows running nightly - Nurse1, Nurse2, etc.) In Power Automate, to make the connection to the staff calendar (in my scenario the nursing station account) do the following: Once you have added the Get calendar view of events (V3) action to your flow, click on the action's menu (the ellipsis located in the action's title bar) Select the staff account under My connections or if necessary, select +Add new connection, select the staff account and provide the account password. Using the document I attached to the original post, add the remaining actions. Let me know if you have any specific questions about the flow or anything else I can do to help you get started. ~Kimberly18KViews1like8CommentsRe: Extracting custom fields from bookings
Steve_Prentice I know! I feel your pain. It seems that it will only pull about 255 records with the Get Calendar events action. That's why I created multiple scopes with a defined date range that wouldn't exceed 255. Luckily, the array variable was able to hold them all and I didn't have to create multiple arrays.18KViews0likes0CommentsRe: Extracting custom fields from bookings
AndyfF360 I was able to extract custom field data successfully using Power Automate so in case you have future needs. Karine2411 , sagark92 , maynarp , topcat437 , Steve_Prentice in case you are interested. Flow Description This flow runs nightly and extracts user data from events located in a custom account calendar (this account is being used by the Bookings app to schedule appointments) then creates a CSV file stored in a Shared Documents team library. Attached are the details of my solution. Hope this helps! ~Kimberly19KViews2likes16CommentsRe: Custom Fields in Microsoft Bookings
jbailiss I was able to extract custom field data successfully using Power Automate. Lobsang_aka in case you have future needs. Martin-Coupal here is another approach in case you are interested. Flow Description This flow runs nightly and extracts user data from events located in a custom account calendar (this account is being used by the Bookings app to schedule appointments) then creates a CSV file stored in a Shared Documents team library. Attached are the details of my solution. Hope this helps! ~Kimberly18KViews0likes13CommentsRe: Microsoft Forms: Ranking question type calculation methodology
Jon_Kay Yes that seems to be the case. I was able to find a RCV tabulator. So for my purposes, I'm using the MS Forms Ranking question type to collect votes. When the voting is over, I will open the results in Excel, convert the ranked candidate cells to columns, save, and then use the RCV tabulator. It's going to be interesting to see if the results will be the same. Thanks!25KViews0likes5Comments
