SharePoint Online
11 TopicsManaged Metadata Column, Term Label Returns Some ID Instead of Actual String Value
I have a flow which will get file properties from a library that contains a managed metadata column. But when I run the flow, the term label value returns some ID instead of the actual string value. The actual Label value should be something like "Fire Protection" and not 109. I can't find a way to get the Label string using any other way. Is this the actual behavior or it's a bug? I'm not sure. Is there any other way to get the Label value? Thanks.SharePoint Data Source Environment variables Choices field issue
Hi, We are trying to create a solution package for our SharePoint list based Canvas app so that we can deploy this solution from Dev to Prod environment by just updating the environment variables SharePoint Site and List data source while importing the solution. We are using SharePoint Data Source Environment variables for this task so that there would not be any need to update the data source after the app is imported to production. Ref Link: https://matthewdevaney.com/simplify-importing-exporting-power-apps-with-datasource-environment-variables/ Everything works fine but when we are tested our app deployed in the production, we found Choices fields in the app were creating issues for us. It seems choice field is still trying to get the reference from old dev site list GUID. Any help will be appreciated to resolve this issue. ThanksError handling in Remove Function of PowerApps is not working properly
Hi Techies, We are trying to implement error handling for Remove function in PowerApps using Errors() function and it seems, it is not working properly for us. Scenario: We have built a PowerApps for SharePoint custom list. Our requirement is to capture the error, if user who is trying to delete the record is not having required permission to delete an item from the SharePoint list. As shown in the below error screenshot, it always shows option 1 i.e. "Request deleted successfully..." irrespective of User is having permission or not to do it. Although, it is not removing the item from the gallery but it always shows success message and Errors() function is not capturing the error in this case. Please let us know what we are doing wrong here and what is the best way to capture errors for Remove function in PowerApps. Thanks, KrisFlow to delete a document added to a list and also from the document library it exists in
Hello, I've created an approval workflow where users can request a document be deleted by adding it to a certain list. The flow works, but only deletes the document from the list. I need it to be deleted from the library is resides in also. There are multiple libraries involved, so the flow needs to find which one it is in. Not sure what I need to add to my flow to accomplish this. Thank you for any support!Can we update Created By using Power Automate?
Hi Team I have 2 SharePoint Lists , List1 and List2 Using Power Automate, I am creating an entry in List2 when an item is created in List1. Created By for List2 item is always a connection which I use in the flow. I want to show Created By of List2 item as the original creator (Created By of List1). Thanks in advance.flow to sync SPO list with SQL table
so I'm developing in SPO and got into an issue with >5k list items. Fixed that with creative filtered views, then another issue sprang up. The list in question now has 7500 or so items in it, and we need to report on the data, and therefore need to have a complete data set. So using the creative filtered views (quarterly dated) I exported all the data by opening each view in turn and exporting to excel, then cut and pasted from all to first sans table headings and viola I got a complete list. I'm now attempting to make this a little more robust so thinking of building a Flow to sync modified or new items to a SQL table. Using the on premises data connector I was able to insert row and update row just fine to SQL. To determine if the flow run was inserting or updating I put a column in the list with a number, and tested if that value was equal to 0, if so I inserted, else updated. The problem with this approach is that somewhere in the flow I it was necessary to update the list to increment the count, and if you are following this logic you may have just figured out that this creates a recursive loop. Then I switched to using a query or stored proc in sql, and got an error saying the data connector didn't permit use of a query. I think I could do this with Layer2 (have used that in the past), also had good luck running codeplex SSIS SharePoint list source and destination connector for something similar. In my current contract I need to not purchase 3rd party s/w, and have not been given MSDN (VS) to play with. Anybody got any suggestions? Thanks in advance!SolvedConfiguring approvals for lists and libraries
We are adding a new menu item under the Flow menu that will let customers configure the type of approvals they would like to use in their lists and libraries (Request sign-off, or Content approval), or turn approvals off altogether. We have added this feature based on the feedback that we received for the rollout of the Request sign-off feature, where some customers preferred to use the Content approval feature which changes the visibility of the current item based on the approval status, and there are fixed approvers for a given list or library, or other customers had other custom flows configured for their list or library, and did not want to have Request sign-off to become a source of confusion for their users. To make changes, as site owner, you will be able click on Flow->Configure flows in the command bar of your list or library: Then in the panel that appears, pick the approval method that you'd like, or turn approvals off altogether: The new configuration panel will become available for our Targeted Release customers in early September, and then go to the rest of our customers. We expect to complete the rollout by September 19. Please continue to keep the feedback for our features coming, and tell us how we can make SharePoint work better for you.Can I create a flow that from SharePoint root site?
I am having trouble creating a flow from a list on my root site. Flow doesn't seem to find the lists within the root site (it does when I put in other 'fuller' site collection URLs). Has anyone else done this? What else can I put in other than "https://<tenant>.sharepoint.com" Thanks, Paul