cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Can't see Lookup Column in Calendar in MS Flow

I am trying to use Flow to create a new Event in a Calendar on my site, triggered when someone creates a new list item in a different list (on the same site.)

When I am using the Create Item action, the available fields don't show either of the two lookup columns in that list item. I'm using the Event content type: those columns are not part of the Content Type, although other fields that aren't included in the Event content type DO appear.

Is this a known thing? How can I set that value?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Can't see Lookup Column in Calendar in MS Flow

Ahh! Despite some key differences I still notice, I believe I found an explanation.

 

(FWIW--not that it really matters--it was the Calendar list in which I'm trying to create the item that lacked the column, not the source whose value I want to copy. Still, I suspect it would affect both the Source and the Destination.)

 

It seems that the owner of the calendar had set the LookUp column to pull "Title (Linked to Item)" rather than just "Title." After tweaking it, it now appears in the list of available columns for that Calendar.

 

Nonetheless, I'm curious why no calendars appear as selections in the drop-down "List Name" choices. I need to use the GUID to bring it up. Not a show-stopper, but it would be mighty convenient to know more about how the drop-down lists for Site Address and List Name get their values. (No matter how often I work with a particular site, it never appears in that list like it would with an MRU list. I'm working in a corporate environment, and I wonder if that's out of my control?)

 

Thanks for looking at this, though!

-That's what you do in a herd: you look out for each other.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Can't see Lookup Column in Calendar in MS Flow

Hi @mboonie,

 

How is your flow created? Could you share a screenshot? It seems that your flow is triggered by When an item is created, then create an event on a Calendar list. And there are two lookup columns in the list, but the two lookup columns don’t appear in the dynamic contents.

 

I have made a test on my side the lookup columns can be selected from the dynamic contents. Please check the following screenshot. Please share more details to help reproduce this issue.

1.PNG

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Resolver I
Resolver I

Re: Can't see Lookup Column in Calendar in MS Flow

Ahh! Despite some key differences I still notice, I believe I found an explanation.

 

(FWIW--not that it really matters--it was the Calendar list in which I'm trying to create the item that lacked the column, not the source whose value I want to copy. Still, I suspect it would affect both the Source and the Destination.)

 

It seems that the owner of the calendar had set the LookUp column to pull "Title (Linked to Item)" rather than just "Title." After tweaking it, it now appears in the list of available columns for that Calendar.

 

Nonetheless, I'm curious why no calendars appear as selections in the drop-down "List Name" choices. I need to use the GUID to bring it up. Not a show-stopper, but it would be mighty convenient to know more about how the drop-down lists for Site Address and List Name get their values. (No matter how often I work with a particular site, it never appears in that list like it would with an MRU list. I'm working in a corporate environment, and I wonder if that's out of my control?)

 

Thanks for looking at this, though!

-That's what you do in a herd: you look out for each other.

View solution in original post

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,650)