Create an event from Excel

(0) Share

Report

Posted on by nshaw75

438

Hi guys,

We have an excel spreadsheet which has information about the activities going on during the week. I am wanting to automatically create an Outlook Calendar invite for my team, for each entry to keep track of everyone. I have tried with Power Automate using the "List rows present in a table" action but haven't managed to make it work.

The table (below) is formatted as a table in the Excel sheet and the file is kept on our companies SharePoint. Any help would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

Power Platform 1919 1,896 on at

Like (2)

Report

Hi @nshaw75 , can you share any screenshots of the flow you have designed to look at and comment on the same

1 people found this reply helpful.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

What's your question?

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

Hi @Power Apps 1919

I have the following and although there are no errors, it doesn't work. I am no doubt making a mistake in the trigger, using a scheduled flow but I couldn't find a trigger which activated when an Excel row is added.

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 1,896 on at

Like (1)

Report

Hi @nshaw75,

For Excel, we don't have any automated triggers (When a row is created or modified etc.) like SharePoint lists.
only option is either move the data to SharePoint list and an automated flow.
or use the existing setup, with a new column (flag) to remove already done records - when calendar event is created - update the record (flag to true) and go on

1 people found this reply helpful.

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

Hi @Power Apps 1919,

Thanks for the reply. I was thinking the exact same thing this morning to have a flow to automatically copy the details from the Table to a SP list, then another flow to create the calendar entry from the SP list.

I had a quick go and I have just come up against a small issue that SP does not like the date format that excel has for the dates. One door opens, another one slams straight in your face 🤣

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 1,896 on at

Like (0)

Report

Hi @nshaw75 , can you share the problem (screenshot) with dates from excel with share point list.

I can help with that

1 people found this reply helpful.

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

Hi @Power Apps 1919

Thank you. I have set the flow to be a scheduled trigger, then have a 'List rows present in a table', then a 'Get Items' from my SP list. Using a unique identifier (Title) as a FilterQuery/key column for both lists.

I have then added a condition length(outputs('Get_items')?['body/value']) < 0 to check whether there is an entry already in the SP list.

Under the True action I am using an Update Item action and for False it is a Create Item action. Then using the dynamic content from the Excel List items action.

It saves fine, but when Testing I am getting the following error which I am putting down to the Excel date formatting which is dd/mm/yyyy

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/StartDate' is required to be of type 'String/date'. The runtime value '"46024"' to be converted doesn't have the expected format 'String/date'.

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

@Power Apps 1919

I have had a look at the Sharepoint side of the issue and I am not sure if this would affect the issue. The Dates are formatted as below and there are badges next to the column headers which indicate the timezone is (UTC-8:00) Pacific Time (US & Canada) whereas our timezone is UTC 0.00 BST/GMT

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 1,896 on at

Like (1)

Report

HI @nshaw75,
Check these links:
1. https://ryanmaclean365.com/2020/07/28/converting-excel-date-time-serial-values-with-power-automate/
2. https://tachytelic.net/2020/11/convert-excel-dates-power-automate/

1 people found this reply helpful.

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

@Power Apps 1919

Thanks very much. I will say, don't get me started going on about Microsoft and how they create platforms which cannot speak the same language. This is a casing point :( as Power Apps understands the dates, but Power automate doesn't .

I will go through the help you have given me and hopefully get to the solution.

Thanks again for your help

Was this reply helpful? Yes No