Idea for flow, is this possible?

(0) Share

Report

Posted on by Rasmusdahl

Hi there!

I would like to make a flow, that uses exel and outlook meetings.

When i schedule a meeting in outlook, i want some of the text from the text field, to transfer to our budget, that we have in exel.

Alternativley, if that isn't possible, i want to write the customers information in our budget exel, and then have it send out a meeting invitation, with text pulled from the exel sheet. Is this possible?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

As far as I know, it currently isn't possible to take a substring of a text.

The other way is to make use of "Onedrive - when a file is modified" to trigger a change of the excel-sheet.

However with a sharepoint list this would be easier to realize.

Was this reply helpful? Yes No
Rasmusdahl 4 on at

Like (0)

Report
Copy link

Link copied!

I have no programming experience what so ever, so i would have to have this made. Could you roughly scetch what information i should have ready, to make the programmers job easier?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Would you like to use sharepoint list or excel file?

Was this reply helpful? Yes No
Rasmusdahl 4 on at

Like (0)

Report
Copy link

Link copied!

We are currently using excel for all our budgets, so i think it would be difficult to teach a whole company to use sharepoint.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Create an Excel file in OneDrive and add two pages to it. One for new meetings and one for the history. Add the columns you need to both pages and Name both tables

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Rasmusdahl,

So basically you would like Microsoft Flow to create an Event with the information from Excel, right?

There is no corresponding Excel trigger to work, so if we would like to take use of the information from Excel, we need to use the Get Rows for Excel. (There is also another action called Get Row, which would need the special Row ID, as the Row ID is auto-generated by the Flow service, so here this action should not be the first choice).

After the Get Rows Action from Excel, we need to add a condition to filter the special Text fields, if not, Microsoft Flow would generate Events as many as the row number in Excel.

After that, under the if Yes part, add the create Event action, see screenshots:

For the trigger, is there any other services that we may take use of, for example, Email?

If we could use Email as the trigger, then the flow here should be much easier.

Please reply back if you need any further assistance.

Regards

Was this reply helpful? Yes No