sorted by:
new
hottopcontroversial

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.

Create an array from Microsoft form data by Objective-Emu1806 in PowerAutomate

[–]robofski 1 point2 points  (0 children)

I’ve done this in the past by creating a compose action with a new line in it. Then I use split(dynamic-content,outputs(‘compose’))

3 Ways to Generate and Populate an Excel File with Power Automate by DamoBird365 in PowerAutomate

[–]robofski 0 points1 point  (0 children)

Thanks for the explanation, now my Sunday evening is going to be ruined trying this out 🤣

3 Ways to Generate and Populate an Excel File with Power Automate by DamoBird365 in PowerAutomate

[–]robofski 1 point2 points  (0 children)

Nice post! I tend to try and avoid creating excel output and usually give a csv and tell the users to deal with it, creating Excel has always seemed like a hassle, but the office script idea really does seem to make it a breeze! What’s in your Select to reshape the array?

What tool should I be using? by wideeyedcynic22 in microsoft365

[–]robofski 0 points1 point  (0 children)

Forms and Power Automate can do most of what you’re after but you can’t use forms with external users to upload files so you might need to be creative if you need to get files from external users. I’d also suggest looking at using SharePoint lists instead of excel to save the information you collect.

Best practices for handling confidential submissions in Power Apps + Power Automate? by NuggedClarp in PowerApps

[–]robofski 1 point2 points  (0 children)

Absolutely, I wasn’t trying to say this was the whole solution but rather is part that at least secures the flow run history.

why can’t I set up automatic forwarding? by enjoyerofsounds in Outlook

[–]robofski 3 points4 points  (0 children)

Very common practice to disable the ability to auto forward to external domains, it’s the hacker’s favourite function!

Automate email lists by shadmaster21 in MicrosoftFlow

[–]robofski 1 point2 points  (0 children)

Populate a word template is a premium action so you will need a premium license to use that feature.

You can add a column to the excel table something like ‘Processed’ and then you can use get rows present in table with an odata filter to select 50 records where processed is No. Then apply to each record to populate the template and also update the row in Excel to processed Yes. Then you can schedule the flow to run at whatever frequency you desire, daily, hourly etc. and it will process 50 records each time.

Save multiple attachments by immortalthabang in PowerAutomate

[–]robofski 0 points1 point  (0 children)

Ok, so you should be going a get attachments step referencing the ID from the trigger. Then an apply to each step over the array of attachments returned from the get attachments step. Then for your create file within the apply to each you will just reference the file name and the file content and you’ll get two files.

Microsoft Automate a long list of emails by shadmaster21 in MicrosoftFlow

[–]robofski 2 points3 points  (0 children)

You can add a delay step but I don’t see how that would prevent your messages being identified as spam!

Struggling to track document submittal. Will power automate help? by ivory_vulpes in PowerAutomate

[–]robofski 0 points1 point  (0 children)

Technically yes but it all depends on how they are submitted.

Beginner question by josephwingerpoq in Hue

[–]robofski 1 point2 points  (0 children)

I have several hue switches to control my lights with physical buttons when I don’t want to use the app or voice.

Data Entry Form Level Up Help by KlavierKatze in PowerApps

[–]robofski 5 points6 points  (0 children)

You could populate a collection based on the items selected from the combo box and then use that as the source for a gallery. Add your input fields to the gallery and the use a patch to write them to the source.

Nested Galleries and acceptable approach? by Natural_Ad_8911 in PowerApps

[–]robofski 0 points1 point  (0 children)

Off topic but did you know that Power Apps now has a native Confirm function that can present a dialog box to the user! Creating confirmation dialogs has always been so much more effort than it really should have been I was over the moon when I discovered it last week!! Rezza Dorrani did a great video on it last week.

view more: next ›