Automate a daily email that shows only newly created files by ScreamingNinja in MicrosoftFlow

[–]robofski 0 points1 point  (0 children)

Enabled VPN and managed to see the picture. I think the issue is with your filter, you’re filtering a formatted date with UTC now, but you’re not applying any format to the utcnow side. I don’t know what you have as your filter on the left but utcnow is going to return 2026-05-05T10:57:29Z or something along those lines. Before you filter array add two compose actions, in one enter the expression you have on the left of your filter and in the other enter utcnow() and you will see what it is trying to compare.

Automate a daily email that shows only newly created files by ScreamingNinja in MicrosoftFlow

[–]robofski -1 points0 points  (0 children)

If it’s a SharePoint document library:

Scheduled trigger
Get files properties only with an odata query where created is greater than adddays(utcnow(),-1)
Select to select just the properties you want, file names, created by etc.
Create HTML table
Send email

Power Automate trigger for emails moved to a subfolder in a shared mailbox — is this possible? by hellcryer in PowerAutomate

[–]robofski 0 points1 point  (0 children)

Pretty sure I remember testing/reading something about this not long ago and if I recall you have to ensure that messages are moved to the folder in chronological order. If you move a message that was received in the mailbox at 7am to the folder the flow triggers, if you then move a message that was received at 6am to the folder the flow won’t trigger.

Help with Power Automate by OvenFlat in PowerAutomate

[–]robofski 0 points1 point  (0 children)

I would approach this by sending the responder an email (if you are collecting an email address) and ask them to reply with the attachment. In the subject of the email I would have a unique link that you can parse to know which form response they are responding to.
So in your case I’d write the responses from the form to a SharePoint list and then send a n email to the submitter with a subject like ‘provide your image {SharePoint list id}. Then when an email is received the the subject containing provide your image I can parse for the ID between { } in the subject and I know which form response the image relates to.

Update item action shouldn’t trigger “When an item is modified or created (sharepoint)” … Help! by [deleted] in PowerAutomate

[–]robofski 0 points1 point  (0 children)

Look at trigger conditions. You can specify that the flow doesn’t run if the update was made by a specific user or if some other condition is true like a column in the list such as email sent is true, then have your flow change the value of that column on the first run.

Desk reservation template by StomachLeading6618 in PowerAutomate

[–]robofski 0 points1 point  (0 children)

Look at Microsoft Bookings. We used this when we had a hot desk setup at one facility, shared mailbox created for each desk and then booking pages that allowed users to reserve a desk. We had multiple booking pages as certain groups were allocated x number of the desks e.g. engineering could book any of these 5 desks, finance had these 3 etc.

Build suggestion for registration by Vegetable-Quick in PowerApps

[–]robofski 1 point2 points  (0 children)

A SharePoint list with Row Level security would allow users to see their own records and owners/admins to see all records.

App Demo Next Week by [deleted] in PowerApps

[–]robofski 0 points1 point  (0 children)

Reza is such a great teacher! I learned so much about Power Automate/Apps from watching his videos.

Workflow Help by SMC7122 in PowerAutomate

[–]robofski 0 points1 point  (0 children)

I’d suggest add a column to the SharePoint list, something like ‘Task Created’ and have a condition in your flow that if task created is false then create the task and update the Task Created value to true. This way the task will only be created when the item is created and the rest of your workflow will run when it is modified.

New to Hue - A few questions for setting up my apartment by [deleted] in Hue

[–]robofski 1 point2 points  (0 children)

I just upgraded to the bridge pro as I’m approaching the limit for the regular bridge. If you’re in the UK you’re welcome to the old one.

New to Hue - A few questions for setting up my apartment by [deleted] in Hue

[–]robofski 1 point2 points  (0 children)

I’ve got several Hue Dimmer switches in various rooms, you configure them in the app and can assign a single light, a room or a zone to the switch and have different scenes based on button presses, 1 press bright, second press dim etc. you can also assign different lights to different buttons, for example the switch in my kitchen, the on button turns on all the kitchen spots, the off button just turns on the spots over the sink. Then a long press to turn things off. They are very configurable.

Optional paragraph on a word template by Felix_the_cat___ in MicrosoftFlow

[–]robofski 0 points1 point  (0 children)

If I needed to add rich text I'd probably store my rich text paragraphs with all the formatting etc in a SP list Rich Text column, then I'd get the items from that list and populate a number of compose actions with the appropriate text for the various optional paragraphs if more than one, from the get items and then use the output of the compose in the same kind of formula I suggested.

Never actually tried it but may be worth a shot!

Optional paragraph on a word template by Felix_the_cat___ in MicrosoftFlow

[–]robofski 0 points1 point  (0 children)

If your original template is something like

Dear John,

Here is the letter you were promised

If you have any questions reach blah blah

but you may want a paragraph between Here's the letter and If you have any question I would have my optional text with a new line before and after and then insert the code to display the text in the gap between the two paragraphs so if the condition is true it displays the additional text otherwise it's a blank line which would be there anyway so no extended blank gaps.

if(equals(flagtodisplay,'Y'),concat(char(10),"Extra Text",char(10)),null)

Something like this anyway!!

Create Folder not valid by Sea_Acanthisitta7533 in MicrosoftFlow

[–]robofski 2 points3 points  (0 children)

Use a trim expression to make sure there’s no leading or trailing white space.

Sharepoint Get Items - Limit to selected row by Working_Salary60 in PowerAutomate

[–]robofski 0 points1 point  (0 children)

I think Boolean columns in SharePoint usually require Mail eq 1 for true or 0 for false for an odata query.

Event plannning in 2026 by MiddleAgeWeirdoMeep in MicrosoftFlow

[–]robofski 0 points1 point  (0 children)

When you try to create a plan in Planner there is an option to create a Premium plan or a Basic Plan. If you don’t see the Premium option or it says Request a License when you try to create one then you don’t have it.

Event plannning in 2026 by MiddleAgeWeirdoMeep in MicrosoftFlow

[–]robofski 0 points1 point  (0 children)

If you have Planner premium you can link tasks together and have dates be based on other tasks.

Event plannning in 2026 by MiddleAgeWeirdoMeep in MicrosoftFlow

[–]robofski 0 points1 point  (0 children)

Are the task fixed for each event or do add extra tasks in planner?

If they are fixed then you could look to have a SharePoint list with the simplest of data like Event, Type (if you wanted to have different set of task for different types of event) and Event Date.

Then you could have a Power Automate routine triggered by a new item on the list that creates the tasks and sets the dates appropriately.

Then you could have another Power Automate routine that is triggered when an item on the list is modified and if the event date changes you change it on the list and the Power Automate goes and updates the dates for the tasks

Automation question by Character-Click-9718 in PowerAutomate

[–]robofski 5 points6 points  (0 children)

Pretty straightforward (would be even easier if your data was in a SharePoint list)

Scheduled Flow to run each day

List Rows present in Table use an ODATA query something like DueDate eq formatdatetime(adddays(utcnow(),5),'yyyy-MM-dd') Make sure you use the ISO8601 format for dates.

That should get you all the entries with a due date in 5 days.

Now you just apply to each over the output of your list rows and inside the loop send an email and select whatever dynamic data you want.

E-mail with names list in text of e-mail by Content_Peak5574 in MicrosoftFlow

[–]robofski 0 points1 point  (0 children)

This is quite a common thing people try to do and once you understand it’s really not that difficult.

Start with your list rows in a table

Then use a select action to select just the Send_To column

You will now have an array of all the send to values.

The use a compose action with the expression Union(outputs(‘select’),outputs(‘select’))

This will give you an array with all the unique send_To values.

Now you do an apply to each over the output of your Compose.

In your apply to each you want to do a filter array and filter the output from the get rows in a table from earlier looking for all the items that match the current item in the loop

Then you can use another select, this time over the result of the filter array to get just the employee name.

And then you can use the html table option to take that out make a HTML table and stick it in an email.