GA4|Looker Studio - Combining on site search term and items added to cart

[midwake]

I'm trying to recreate an existing Looker Studio dashboard where search terms and items added from that search results page are combined using data from Universal Analytics.

The search query was was extracted from the URL and product name was from the event label of the event 'add to cart'.

For example, a customer searched the term 'bananas' in the search bar and added the product ' 0004| 3 lbs bananas' to cart from the search results.

'bananas' was extracted from the URL "www.example.com/q=bananas" and product name was extracted from the event "event category: Ecom event action: add to cart event label: 0004| 3 lbs bananas".

I'm trying to recreate the same in Looker Studio using GA4 data. I am trying to combine  'page path + query string' and 'item name'. But it is throwing a configuration error.

The only combination that works is 'item name' and 'page path and screen class'. But using this I won't be able to extract the search query.

Note : I'm able to recreate this using a free form Exploration in GA4.