Power Automate ‑haku

Haku

Re: Flow Owner name appears on approvals and SharePoint list

Yhteisö

@jaxkookie  You are correct!  That said, I didn't include that in my response as I have never had success adding/changing the connection for an approval action.

Re: Microsoft forms not triggering flow

Yhteisö

None of the form submissions have gone through the Power Automate (Flow) starting at 4:37pm EST 12/8 for us. 

Re: get items error

Yhteisö

@zmohamed  Can you post a screen shot of your Flow in edit mode?

Re: Manually trigger a flow from a PC/laptop

Yhteisö

Yes sounds very easy to those who are into doing that. I'd prefer a simpler method. Not everyone has the time or the inclination to be bothered with this stuff. That should be behind the scene. Those...

Re: Unable to get a shared onedrive file

Yhteisö

@MarkAldous  The issue is the the Get file content action that you are using is a OneDrive for Business action - it will only connect to your OneDrive - no way around this.     ...

Re: How to add author to Tweet Text?

Yhteisö

Okay, thanks for the info.    Was hoping it would just require a custom expression....  like triggerOutputs()?['body/dc:creator']   (tried this, didn't work).   ...

Re: My scheduled flow is just stopped or stuck running for 5 days.

Yhteisö

Suddenly the flow started to work like magic, despite taking no action.   I haven't figured out a solution, but it's really fortunate anyway.   I hope no one else is experiencing the sa...

Auto Assign Tasks to Pool of Users

Yhteisö

Hi all,   I've currently built a flow that will check the created time of an item in a SharePoint list and use two columns to determine if the created (current) time is within the user's prede...

Use Power Automate to password protect Word documents in Sharepoint

Yhteisö

Background: We have an online Dynamics 365 system that creates some legal documents. The legal documents are created as Attachments linked to the Case. The legal documents are Word documents and are ...

Re: Limit Columns by View in Get Items doesn't work

Yhteisö

Yes, I got it working as you described. Thanks again!

Re: Converting String to integer in Select action

Yhteisö

Hi @upputuriyamini2,   Use int() function to convert a string to an integer, we should make sure the string is a number. Please share an instance of the filter array, it could help us...

Re: Convert word document to pdf for document already in SharePoint library

Yhteisö

Hello @xxxxmints  In which action are you receiving this error? Regards, Ferran

Re: Office 365 Group email Trigger

Yhteisö

Hi @balajinarni, did you see https://flow.microsoft.com/en-us/blog/use-our-new-office-365-groups-mail-connector/ ?

Validate date array

Yhteisö

I am trying to validate a date at the beginning of a file name. They usually start like this YYYY-MM-DD (then the rest of the file name). I am at the point where I have used substring to get the firs...

Re: Get emails (V3) - action if no results

Yhteisö

thanks Scott, this worked a treat.  you've saved me some time  😀

Re: Update list item when a file is created/modified in a library folder which was created/triggered by adding an item to this list.

Yhteisö

Can you export the flow, and provide the exported file, i am not getting idea where exactly your flow is going wrong, when file is added, the flow triggers only once, thats what happens on my end.

Re: Handling Excel Online Dates

Yhteisö

So a weird workaround for this is to use dd/MMM/yyyy as the format within Flow which generates the date as 08 December 2020 for example and removes the problem between recognising US and UK dates.&nb...

Re: Create Item in List Called with Dynamic Content

Yhteisö

@annajhaveri I've fixed that missing comma. I am still getting the same error that I was receiving up above. That: A type named 'SP.FieldURLValue' could not be resolved by the model. When a mod...

Re: Update list item when a file is created/modified in a library folder which was created/triggered by adding an item to this list.

Yhteisö

okay, i am little confused as you are facing two issues, lets go one by one, were you able to get the Item ID from the folder in the library flow? did that worked successfully?

Re: Prevent 'For Each' container when using Approval action.

Yhteisö

Hello @krp28 , you can avoid 'Apply to each' if you use first() expression on the array and define which dynamic content you want to use. An example below that will return 'Id' of the firs...

Re: Insert the record into SQL database from CSV file located on Sharepoint

Yhteisö

Is there any option where the data doesn't go to third parties?

Re: Request approval (everyone must approve) for a selected file - Template

Yhteisö

Tried it on another tenant and has the same issue

Outlook Send Email V2 - Selecting One File From a SP Site With a Dynamic Path?

Yhteisö

I have a flow that takes 4 vars from Power Apps and uses them to populate an Outlook Send Email V2 form.  Receiving the vars from Power Apps and using within the email has been tested and works ...

CRM - SAP Integration

Yhteisö

Hi,   Can we integrate MS CRM to SAP using flow. Ex. When I create account in MS CRM then account should be create in SAP as well. How can we achieve it? or the best way to achieve it.  ...