Відео

Offline syncing can be disabled at the list/library level or the site level (which will disable it on ALL lists/libraries in the site). This more recent video shows how to do that with Powershell. So, not "one click", but "one cmdlet" (once you're connected to the site using Powershell).

If you're using the new designer, this is normal (and incredibly annoying). You should be able (in most cases) just drag those actions out of the loop.

@@cvkealey Thanks for the quick reply. I notice I also don't get the same choices you showed. You had three versions of the choice column: columnName, columnName Value, columnName items. Could it be because I'm doing a get item first in my flow and then trying to copy?

You need to repeat the parse json action for each question and append them all to the same array variable. See ua-cam.com/video/2mrcTMkwelE/v-deo.htmlsi=4d8Xk9W2wVqcr1Oj for more details.

If you have multiple "file upload" type questions, you need to repeat the steps for each question. If you want to do the same thing with all the files (e.g.: in your case, you want to link to all of them as "references"/attachments), you can append the appropriate information into the same array variable and then attach that variable. For more details on the response format, see this playlist: ua-cam.com/play/PLMVyjgrWIGnwQowO2RsvHg0pZ8EozvAG-.html

The array of objects format that I'm showing is required to load data into a SharePoint multi-select choice column. If you're doing something different (e.g.: writing it into Excel), you need to use a different format. What format, specifically, depends on what your data looks like and what you want the output to look like.

Sure. Just plug the responses into the same field with a separator of your choice (line break, semicolon, etc)

You can save presets, but it's not incredibly intuitive as to how. Basically, when you select a video codec (e.g.: x264) and click settings, there's "Presets" drop down at the top. I'm blanking on what the interface looks like at the moment, but there is a way (a button?) to save a preset. I have 3 or 4 custom ones I use for different purposes. But, overall, the app is not super intuitive. It's very powerful, with lots of bells and whistles, you just need to figure out how to work them. Considering it's a 100% free app (no ads, no subscription), I'm willing to accept that tradeoff. If you're not, well, that's why there are plenty of other options at varying price points.

Sorry, I'm not sure I understand your question. I do know that you can't send mail *from* a teams channel. It's not a mailbox.

@@cvkealey I want to set up a recurring task in Power Automate to capture Teams messages from a specific channel (between timestamps), save them to OneDrive in a file, and email them to a designated ID.

@@RamKumar-jo4iu I don't believe that's possible with out-of-the-box actions in the Teams connector. There's a "get messages" action, but it only takes the team and channel as inputs, so it's not possible to filter the results to a specific time frame. I mean, if you REALLY need this, the simplest way would be to use an automated flow (when a message is sent in channel) to record the relevant data (like the message ID) to a table or list along with a sent timestamp, then have your scheduled flow check that list (get items) and filter to sent timestamps within the window. It'd be a lot of work and probably not worth it, but I don't know your use case/requirements.

@@cvkealey Thank you for the detailed response and suggestion. I will try and let you know

The "path to file" dynamic content will only work if the file is stored in SharePoint itself; you'll need to use the "Get file content" action first to get the file from OneDrive and then pass it as the "File Content" input to the "Create file" action in SharePoint.

Yes, they added attachments at some point in the past couple months. I think it's limited to one field/question, so not quite as flexible as "file upload" questions in a Forms form, but definitely more convenient.

Are you sure you're putting double quotes around the dynamic content values there? JSON is a very strict and picky markup language.

If you mean the value for the varPriorities array (see around the 8:00 mark), that's available in the description of the video. If you mean something else, please explain.

@@cvkealeymy apologies, I didn’t realize it was in the description. Great videos, you’ve earned a subscriber!

No worries. I don't think I mention that in the video, so it's easy to miss. If you're looking at any other content of mine, I try to include those sorts of things (where possible) in the descriptions.

The most common cause for that is leaving the . out of the File ID field. It should be <driveID>.<fileID>

It sounds like you may not be selecting a file upload question as the input for that action or you entered an incorrect schema.

See this video for how to get the correct schema: ua-cam.com/video/OaB2stc6ThM/v-deo.html

You don't need the variable. I only used that (and the switch) in my example because I wanted to dynamically build the text to store in the list. In your case, you just need to use the technique demonstrated starting around 7:33 to "drill into" the output of the select action that's extracting the custom questions and answers. For example, if you have a (text) column where you want to store "Case name" and that's the first custom question, you would use the expression body(select_outputs)?[0]?['Answer'] as the input for that field in the Create item action.

@@cvkealey should I use append? When I add that action the “name” doesn’t have a drop down and I have nothing to choose from. The only “set” setting that seems appropriate is maybe the share point one? I only say set because you mentioned it in your video?

I'm not sure what you mean. It would probably be best if you could post a message in the Power Automate community (community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287) with some screenshots and the relevant details.

@@cvkealeybecause when I go from select the next action at 7:33 is the append action but it doesn’t allow me to add a name like it did when I had the variable. Without the variable there append didn’t work the same. There was no drop down (var select qs and as) option.

@@cvkealeymost, if not all, the bookings to share point list are unanswered 😢

If you mean the "Forms" function in Microsoft Lists, that largely eliminates the need for a power Automate flow, but there are still some cases where you'd need a flow. For example, if you want the form to be filled out by people outside your organization.

I understand use cases for forms within lists and generally Microsoft forms. This Power Automate “select choice” option flow, however, only seems to work when applied to a SharePoint library list. With a general Microsoft list, the flow populates a choice field with [“Value”] instead of using one of the selected choices.

Microsoft lists are SharePoint lists. They are the same thing, under the branding. Can you be more specific about the issue you're seeing?

@@cvkealey Yes, they're the same. Within our tenant, the document library looks much like what's at 09:56, but list are updated with what a user would see in the stand alone Microsoft Lists application...I'm not sure how to describe without providing a visual, so will figure it out. Thank you,

Yes, working with libraries is still different from lists, regardless of the similarities in the UI. Working with lists (in power automate) is the same regardless of where they live (personal lists or SharePoint).

Images should work the same as any other type of file. Does this happen with any image files, or only ones of a specific file type (.jpg, .PNG, etc.)?

All the custom questions and answers are returned in an array called "CustomQuestionsAnswers". That's the input for the select action. In the Map, the simple way to get the question and answer values is with the item expression (item()?['Question'] and item()?['Answer']). It's important to note that this only works for 1:1 bookings (not 1:N/group bookings).

@ thanks Chad! This is very helpful!!!

If you're trying to attach the files to an Approval, you need to format the array a little differently. See ua-cam.com/video/Xq6DWuEt-Bw/v-deo.html for details.

Each flow can be linked to a single bookings calendar address, so, yes, you'll need 120 flows. There's no way around that. With appropriate licensing (ie: premium), you could create three child flows to perform all the operations but you'd still need 120 separate parent flows to call the appropriate child flow.

It must be an array. I suspect you're not switching that field to "text mode" (the little icon to the top right of it).

@@cvkealey Thanks for answering! Yes, it's an array. No, I'm not switching. I appreciate your trying to help. YT is not the best format, so I am grateful.

@steprockmedia no, what I meant is that you need to switch the attachments field (in the update task details action) to the other mode in order for it to take the array variable. If you see multiple text boxes in/for that field, click the icon to the right of it to switch modes. I'm just blanking on what they call that (text mode vs array mode, I think). Once the field is set to the correct input mode, you'll be able to add the variable.

@@cvkealey I'll give it another look. Thanks for taking the time to do the vid and reply to people. And yes! It looks like that was the button I missed.

You can't prevent the submitter's name from being appended, but if you're sending the file as an attachment, you can modify the name. See ua-cam.com/video/PRwUn0aZysM/v-deo.html

Yes. The question and answers are returned as an array, so you would need to use the appropriate array notation to retrieve the value you want..

Once you get the content of the Excel file, you could use the method shown here to convert it to CSV: ua-cam.com/video/Ik-TLaMByhw/v-deo.htmlsi=YY0HIFjI0MZ8oGY5

Assuming you're using the "Get response details" action, you should be able to use any of the outputs of that to name the file. Basically, you can name the file whatever you'd like with the exception of illegal characters (for example things like /).

I'm not sure what exactly you're trying to do, but I think troubleshooting through the comments channel here isn't going to be the best solution. I would suggest you post a message in the Power Automate community (community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287) with some screenshots of your flow and a description of the problem.

It sounds like you're using "group bookings" (either 1:N or N:N). According to the FAQ in the connector documentation (learn.microsoft.com/en-us/connectors/microsoftbookings/#faq - point 7 to be exact), only the first person to book a time slot triggers the "when a booking is made" flow. Additional customers selecting that slot should trigger a "when a booking is updated" flow, but in my (very brief and basic) testing, it does not. Even if it did, the fact that the trigger doesn't return data about WHAT changed means that there may not be a way to know that someone has joined that slot.

Thanks

Custom questions and answers come in as an array, so you need to handle them appropriately. This video should help you get started, but ultimately, how you handle your data depends on what you want to do with it (ie: all in one column, in separate columns, etc.): ua-cam.com/video/6fLyGFWKyPE/v-deo.html

​@@cvkealey Thank you so much

What trigger does your flow use? If it's an instant trigger, you can add "run only" users and specify whether they run the flow with your connections or their own. If it's an automated or scheduled flow, you need to add a co-owner and then they need to update the flow to use their connections.

@@cvkealey instant trigger, but it is triggered when someone creates a devops release. Dont think there is run only option

​@joycesoh5876 I think that's an automated trigger, not instant. So, the actions within will run using the connections they are configured to use. So, the co-owner would just need to edit the flow and change those relevant actions to use their connections in place of yours.

@@joycesoh5876 sorry, I may have mispoken...there is an action called "Create a new release" in the Azure DevOps connector, but I don't see a trigger with that name. What is the actual name of the trigger you're using? The ones that support run-only users are (in the SharePoint connector) "For a selected item" and "For a selected file". See learn.microsoft.com/en-us/power-automate/create-team-flows#share-a-cloud-flow-with-run-only-permissions for more details.

I'm not sure how to do that as Microsoft has locked down the UI to prevent that level of customization. The best workaround I can think of would be creating a checkbox column in the list like "run flow" and then create an instant flow that includes a "get items" action that will retrieve items from the list that have that box checked.

Setting managed metadata columns is pretty much the same as setting choice columns. If it's a single-select column, you just need to feed it the value. If it's a multi-select, it needs to be an array of the values in the appropriate format.

@cvkealey exact matched values from form choice to column metadata choices, letter for letter, or is there something else funky with the metadata tags because they are no longer simple choice pills and are in the term store library?

@@chriswho6794 Actually, it's a bit more complicated. The instructions here should help get you there, though: tomriha.com/how-to-update-sharepoint-managed-metadata-column-power-automate/

Yes, it's possible, but I don't have a video on it. Generally speaking, I really like Excel as a tool for recording and viewing data, but for making it actionable, SharePoint/Microsoft Lists is a better choice. The tooling (connectors and actions) in Power Automate for Lists make the process much easier. To do the same with an Excel file, you need to ensure it's in a table, then get the file, get the table, list the rows, etc. There's more overhead involved. BUT, if you're committed to keeping the data in Excel, this video should show you what you need to know: ua-cam.com/video/1g7NA5hYYSo/v-deo.htmlsi=8KGJdNAmvZnv9ZpL