User Profile
stormin_30
MVP
Joined 5 years ago
User Widgets
Recent Discussions
Re: Power Automate get Items filter query
Hi Lukas, Update your OData filter query to include the Modified date. For example: SendReminder eq 'Start' AND modified ge 'addDays(utcNow(), 2, 'yyyy-MM-dd)'. Be sure to use the expression builder for the addDays expression. Add send email action to complete the flow. I hope this helps. NormRe: Copy some columns values from List A to List B based on another columns value
Hi markikav1955, I would look at having two Flow: Import Excel to List B Sync List A contacts to List B The Sync would look for blank entries in List B and populated contact values in List A. If you simplify the tasks it will make this more approachable. I hope this helps. NormRe: Copy some columns values from List A to List B based on another columns value
Hello markikav1955, For all new items created in List A, you could create a simple Flow that would copy the required values to List B using the When a new item is created trigger. For multiple records with conditions in List A, you could create a Scheduled Flow with the SharePoint Get items action. Let me know if you need help with any of this. NormRe: Power Automate/SharePoint Online issue
Hello CR-88, Assuming the button is calling the "For a selected file" trigger it has to be in the default environment. See this link for more information: https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/sharepoint-connector-actions-triggers#for-a-selected-file I hope this helps. Norm919Views0likes1CommentRe: Puxar todos os items de uma lista do Sharepoint e criar uma planilha em excel
Hello experi1610, You will need an Excel "template" file that you will copy, add List items too and then send via email. The template file must match the List schema and must be in a table. I hope that makes sense. NormRe: Create Salesforce item when a new List item is created in SPO
Hi ALDINA3003, If a "record" is the same as a "case" is Salesforce then the template is definitely worth looking into. Here is the Salesforce Power Automate documentation: Salesforce - Connectors | Microsoft Docs The HTTP rest API documentation would come from Salesforce. I would check-in with the Power Automate Community. I suspect more people there have experience with what you are trying to achieve. I hope this helps. NormRe: Importing dates from Excel into Sharepoint list
Hello All, I agree with the approach that RobElliott provided. I've done this before but using a variable (vs compose) to convert and store the Excel date. More details here: Import Excel data into an existing SharePoint List using Power Automate – Norm Young I hope this helps. NormRe: Sharepoint List - Set Calculated Field to Null or Blank
Hi DanZ24, You can test the length of DateCompletedorClosed. If it is 0 then provide a default value like blank(" "). =IF(LEN(DateCompletedorClosed)=0," ",(DATEDIF(DateStarted,DateCompletedorClosed,"D"))-INT(DATEDIF(DateStarted,DateCompletedorClosed,"D")/7)*2-IF(WEEKDAY(DateCompletedorClosed)<WEEKDAY(DateStarted),2,IF(OR(WEEKDAY(DateCompletedorClosed)=7,WEEKDAY(DateStarted)=1),1,0))+1) I hope this helps. Norm20KViews1like1CommentRe: Looking for a SharePoint Contract Management
Hi robearth, I have used SharePoint and Power Automate in the past for agreement & contract management. The solutions were simple and met the requirements. At a high-level the solutions included: List to store metadata: name, contact info, signatory, start date, renewal date etc. Folders to store associate documents. Document Sets would be preferred but the lack of related Power Automate actions was limiting IMO. Power Automate to create folders, execute approvals, send reminders etc. If your company is currently using Excel to manage this process you have a great starting point for your List build. I've included a bunch of links to my blog in this response to try and give you a head-start. I'm happy to help you further with this one. I hope this helps. Norm2.4KViews0likes1CommentRe: Adding a picture to Page Text Webpart
Hi ChrizK, "I want to add a row/column with a small picture and some text around it." Try using Sections to achieve your desired layout. Developing the page in modern SharePoint will be the best development experience. Add the new site page as a Tab in Teams will be an excellent end-user experience. I hope this helps. Norm13KViews0likes3CommentsRe: Filter Query Error
Hi Daniel Bonner, Confirm the column name by going into List settings > column > check the URL path for the internal column name ("Field="). Set the "Get items" action OData filter query to: <your column name> ge 'addDays(utcNow(), 30, 'yyyy-MM-dd')' There are single quotes around the expression! I hope this helps. Norm